DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 1889: FROM bom_substitute_components

1885: he given Change Notice*/
1886:
1887: CURSOR c_sub_comps IS
1888: SELECT *
1889: FROM bom_substitute_components
1890: WHERE change_notice = p_change_notice
1891: AND component_sequence_id in
1892: (SELECT component_sequence_id
1893: FROM bom_inventory_components

Line 3515: FROM bom_substitute_components

3511: -- Cursor to Pick all substitute Component Items for the Top Organization for
3512: -- the given Change Notice
3513: CURSOR c_plm_sub_comps IS
3514: SELECT *
3515: FROM bom_substitute_components
3516: WHERE change_notice = p_revised_item_rec.eco_name
3517: AND component_sequence_id = p_component_sequence_id;
3518:
3519: -- Cursor to Pick all reference designators for the Top Organization for the