DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REV_COMPONENT dependencies on ENG_REVISED_COMPONENTS

Line 3594: AND EXISTS (SELECT 1 from eng_revised_components

3590: (SELECT 1 from bom_inventory_components
3591: WHERE component_sequence_id =
3592: p_rev_comp_Unexp_rec.component_sequence_id
3593: )
3594: AND EXISTS (SELECT 1 from eng_revised_components
3595: WHERE component_sequence_id =
3596: p_rev_comp_Unexp_rec.component_sequence_id);
3597:
3598: --

Line 3853: FROM eng_revised_components

3849: AND operation_seq_num = p_operation_seq_num
3850: ) AND
3851: EXISTS
3852: ( SELECT component_sequence_id
3853: FROM eng_revised_components
3854: WHERE component_item_id = p_component_item_id
3855: AND bill_sequence_id = p_bill_sequence_id
3856: AND effectivity_date = p_effectivity_date
3857: AND operation_sequence_num = p_operation_seq_num