DBA Data[Home] [Help]

APPS.ENG_ECO_COST dependencies on CST_ITEM_COSTS

Line 45: FROM cst_item_costs cic,

41: BEGIN
42:
43: SELECT sum(cic.material_cost)
44: INTO l_items_cost
45: FROM cst_item_costs cic,
46: eng_revised_items eri
47: WHERE eri.change_notice = p_change_notice
48: AND eri.organization_id = p_org_id
49: AND cic.inventory_item_id = eri.revised_item_id

Line 105: cst_item_costs cic

101: from bom_inventory_components bic1,
102: bom_inventory_components bic2,
103: eng_revised_items eri,
104: mtl_system_items msi,
105: cst_item_costs cic
106: where eri.change_notice = p_change_notice
107: and eri.organization_id = p_org_id
108: and bic1.bill_sequence_id = eri.bill_sequence_id
109: and bic1.revised_item_sequence_id = eri.revised_item_sequence_id