DBA Data[Home] [Help]

APPS.BOM_BOM_COMPONENT_UTIL dependencies on BOM_COMPONENTS_B

Line 596: select component_sequence_id into l_src_comp_seq_id from bom_components_b

592: FROM bom_structures_b
593: WHERE bill_sequence_id = p_bill_sequence_id
594: and bill_sequence_id <> source_bill_sequence_id;
595:
596: select component_sequence_id into l_src_comp_seq_id from bom_components_b
597: where component_item_id = p_component_item_id
598: and bill_sequence_id = l_src_bill_seq_id
599: and operation_seq_num = p_op_seq_num
600: and effectivity_date = p_start_effective_date;