cst_perpavg_cost table duplicate rows in Fusion
Summary:
JOIN egp_item_org_associations esib
ON rsrl.item_id = esib.inventory_item_id
and rsrl.ORGANIZATION_ID = esib.organization_id
JOIN cst_item_cost_profiles cicp
ON cicp.inventory_item_id = esib.inventory_item_id and co.cost_org_id = cicp.cost_org_id
-- and cicp.inv_org_id = esib.organization_id
JOIN cst_cost_profiles_b ccp ON ccp.cost_profile_id = cicp.asset_cost_profile_id
JOIN cst_perpavg_cost cpc ON cpc.cost_org_id = cicp.cost_org_id AND cpc.cost_book_id = cicp.cost_book_id
Content (please ensure you mask any confidential information):
0