DBA Data[Home] [Help]

APPS.ENG_ECO_UTIL dependencies on BOM_COMPONENTS_B

Line 991: FROM bom_components_b bcb

987: -- Cursor to Fetch all source bill's component changes that are being updated
988: -- by reschedule
989: CURSOR c_source_components( cp_change_notice eng_engineering_changes.change_notice%TYPE) IS
990: SELECT bcb.component_sequence_id
991: FROM bom_components_b bcb
992: WHERE bcb.CHANGE_NOTICE = cp_change_notice
993: AND exists
994: (select 'x' from bom_bill_of_materials
995: where bill_sequence_id = bcb.bill_sequence_id

Line 1402: FROM bom_components_b bcb

1398: -- Cursor to Fetch all source bill's component changes that are being updated
1399: -- by reschedule
1400: CURSOR c_source_components( cp_change_notice eng_engineering_changes.change_notice%TYPE) IS
1401: SELECT bcb.component_sequence_id
1402: FROM bom_components_b bcb
1403: WHERE bcb.CHANGE_NOTICE = cp_change_notice
1404: AND exists
1405: (select 'x' from bom_bill_of_materials
1406: where bill_sequence_id = bcb.bill_sequence_id