DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on BOM_STRUCTURE_TYPES_VL

Line 826: FROM bom_operation_sequences op, eng_revised_items ri , bom_structure_types_vl st

822: END IF;
823:
824: -- Check whether there are any operations changes created for the item with this change order ..
825: SELECT count(st.structure_type_id) INTO l_pending_changes_count
826: FROM bom_operation_sequences op, eng_revised_items ri , bom_structure_types_vl st
827: WHERE op.revised_item_sequence_id = p_change_line_id
828: AND op.revised_item_sequence_id = ri.revised_item_sequence_id
829: AND op.implementation_date IS NULL
830: AND st.structure_type_id = ( SELECT bbom.structure_type_id