DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on ENG_REVISED_COMPONENTS

Line 6785: AND EXISTS (SELECT 1 from eng_revised_components

6781: (SELECT 1 from bom_inventory_components
6782: WHERE component_sequence_id =
6783: p_rev_comp_Unexp_rec.component_sequence_id
6784: )
6785: AND EXISTS (SELECT 1 from eng_revised_components
6786: WHERE component_sequence_id =
6787: p_rev_comp_Unexp_rec.component_sequence_id);
6788:
6789: --

Line 7071: FROM eng_revised_components

7067: AND operation_seq_num = p_operation_seq_num
7068: ) AND
7069: EXISTS
7070: ( SELECT component_sequence_id
7071: FROM eng_revised_components
7072: WHERE component_item_id = p_component_item_id
7073: AND bill_sequence_id = p_bill_sequence_id
7074: AND effectivity_date = p_effectivity_date
7075: AND operation_sequence_num = p_operation_seq_num