APPS.ENG_ECO_COST dependencies on ENG_REVISED_ITEMS

Line 46: eng_revised_items eri

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
50: AND cic.organization_id = eri.organization_id

Line 103: eng_revised_items eri,

99: )
100: ) item_cost
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

Line 356: eng_revised_items eri,

352: SELECT nvl(eco.estimated_mfg_cost, 0) mfg_cost,
353: nvl(eco.estimated_eng_cost, 0) eng_cost,
354: bom.assembly_type
355: FROM eng_engineering_changes eco,
356: eng_revised_items eri,
357: bom_bill_of_materials bom
358: WHERE eco.change_notice = p_change_notice
359: AND eco.organization_id = p_org_id
360: AND eri.change_notice = eco.change_notice

Line 389: FROM eng_revised_items eri,

385: using_assembly_demand_date,
386: assembly_demand_comp_date,
387: daily_demand_rate,
388: revised_item_id
389: FROM eng_revised_items eri,
390: mrp_gross_requirements mgr
391: WHERE eri.change_notice = cp_change_notice
392: AND eri.organization_id = cp_org_id
393: AND mgr.compile_designator = cp_plan_name