DBA Data[Home] [Help]

APPS.BOM_VAL_TO_ID dependencies on BOM_INVENTORY_COMPONENTS

Line 895: FROM bom_inventory_components

891: END IF;
892:
893: SELECT component_sequence_id
894: INTO l_id
895: FROM bom_inventory_components
896: WHERE component_item_id = p_component_item_id
897: AND bill_sequence_id = p_bill_sequence_id
898: AND effectivity_date = p_old_effective_date
899: AND operation_seq_num = p_old_op_seq_num;

Line 1109: from bom_inventory_components

1105: BEGIN
1106:
1107: select component_sequence_id
1108: into l_id
1109: from bom_inventory_components
1110: where bill_sequence_id = p_bill_sequence_id
1111: and component_item_id = p_component_item_id
1112: and operation_seq_num = p_operation_sequence_num
1113: and effectivity_date = p_effectivity_date