DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 1870: FROM bom_substitute_components

1866: he given Change Notice*/
1867:
1868: CURSOR c_sub_comps IS
1869: SELECT *
1870: FROM bom_substitute_components
1871: WHERE change_notice = p_change_notice
1872: AND component_sequence_id in
1873: (SELECT component_sequence_id
1874: FROM bom_inventory_components

Line 3390: FROM bom_substitute_components

3386: -- Cursor to Pick all substitute Component Items for the Top Organization for
3387: -- the given Change Notice
3388: CURSOR c_plm_sub_comps IS
3389: SELECT *
3390: FROM bom_substitute_components
3391: WHERE change_notice = p_revised_item_rec.eco_name
3392: AND component_sequence_id = p_component_sequence_id;
3393:
3394: -- Cursor to Pick all reference designators for the Top Organization for the