DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on BOM_STRUCTURE_TYPES_VL

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

750: END IF;
751:
752: -- Check whether there are any operations changes created for the item with this change order ..
753: SELECT count(st.structure_type_id) INTO l_pending_changes_count
754: FROM bom_operation_sequences op, eng_revised_items ri , bom_structure_types_vl st
755: WHERE op.revised_item_sequence_id = p_change_line_id
756: AND op.revised_item_sequence_id = ri.revised_item_sequence_id
757: AND op.implementation_date IS NULL
758: AND st.structure_type_id = ( SELECT bbom.structure_type_id