You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!