DBA Data[Home] [Help]

APPS.BOM_VAL_TO_ID dependencies on BOM_INVENTORY_COMPONENTS

Line 870: FROM bom_inventory_components

866: END IF;
867:
868: SELECT component_sequence_id
869: INTO l_id
870: FROM bom_inventory_components
871: WHERE component_item_id = p_component_item_id
872: AND bill_sequence_id = p_bill_sequence_id
873: AND effectivity_date = p_old_effective_date
874: AND operation_seq_num = p_old_op_seq_num;

Line 1084: from bom_inventory_components

1080: BEGIN
1081:
1082: select component_sequence_id
1083: into l_id
1084: from bom_inventory_components
1085: where bill_sequence_id = p_bill_sequence_id
1086: and component_item_id = p_component_item_id
1087: and operation_seq_num = p_operation_sequence_num
1088: and effectivity_date = p_effectivity_date