DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on ENG_REVISED_COMPONENTS

Line 6546: AND EXISTS (SELECT 1 from eng_revised_components

6542: (SELECT 1 from bom_inventory_components
6543: WHERE component_sequence_id =
6544: p_rev_comp_Unexp_rec.component_sequence_id
6545: )
6546: AND EXISTS (SELECT 1 from eng_revised_components
6547: WHERE component_sequence_id =
6548: p_rev_comp_Unexp_rec.component_sequence_id);
6549:
6550: --

Line 6832: FROM eng_revised_components

6828: AND operation_seq_num = p_operation_seq_num
6829: ) AND
6830: EXISTS
6831: ( SELECT component_sequence_id
6832: FROM eng_revised_components
6833: WHERE component_item_id = p_component_item_id
6834: AND bill_sequence_id = p_bill_sequence_id
6835: AND effectivity_date = p_effectivity_date
6836: AND operation_sequence_num = p_operation_seq_num