APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 11031: SELECT mtl_material_transactions_s.NEXTVAL

11027: l_primary_lot_qty := l_lot_rec.quantity;
11028: END IF;
11029:
11030: if l_lot_interface_id is null then
11031: SELECT mtl_material_transactions_s.NEXTVAL
11032: INTO l_lot_Interface_Id
11033: FROM DUAL;
11034: End if;
11035:

Line 11049: SELECT mtl_material_transactions_s.NEXTVAL

11045: )
11046: Loop
11047: -- Generate the serial interface id here
11048: if l_serial_interface_id is null then
11049: SELECT mtl_material_transactions_s.NEXTVAL
11050: INTO l_serial_Interface_Id
11051: FROM DUAL;
11052: End if;
11053:

Line 11112: SELECT mtl_material_transactions_s.NEXTVAL

11108: )
11109: Loop
11110: -- Generate the serial interface id here
11111: if l_serial_interface_id is null then
11112: SELECT mtl_material_transactions_s.NEXTVAL
11113: INTO l_serial_Interface_Id
11114: FROM DUAL;
11115: End if;
11116:

Line 11545: SELECT mtl_material_transactions_s.NEXTVAL

11541: END IF;
11542:
11543: IF (l_mol_mmtt_ctnt_tb(i).lot_number IS NOT NULL) THEN
11544: IF l_lot_interface_id IS NULL THEN
11545: SELECT mtl_material_transactions_s.NEXTVAL
11546: INTO l_lot_interface_id
11547: FROM DUAL;
11548: END IF;
11549:

Line 11699: SELECT mtl_material_transactions_s.NEXTVAL

11695: END IF;
11696:
11697: FOR j IN 1..l_rti_serial_tb(l_rti_index).COUNT LOOP
11698: IF l_serial_interface_id IS NULL THEN
11699: SELECT mtl_material_transactions_s.NEXTVAL
11700: INTO l_serial_Interface_Id
11701: FROM DUAL;
11702: END IF;
11703:

Line 11729: SELECT mtl_material_transactions_s.NEXTVAL

11725: END LOOP;--FOR j IN 1..l_rti_serial_tb(l_rti_index).COUNT LOOP
11726:
11727: IF (l_mol_mmtt_ctnt_tb(i).lot_number IS NOT NULL) THEN
11728: IF l_lot_interface_id IS NULL THEN
11729: SELECT mtl_material_transactions_s.NEXTVAL
11730: INTO l_lot_interface_id
11731: FROM DUAL;
11732: END IF;
11733:

Line 16914: SELECT mtl_material_transactions_s.NEXTVAL

16910: -- l_mtli_rec.transaction_quantity - l_remaining_quantity
16911:
16912: IF (l_mtli_rec.serial_transaction_temp_id IS NOT NULL)
16913: THEN
16914: SELECT mtl_material_transactions_s.NEXTVAL
16915: INTO l_new_serial_txn_temp_id
16916: FROM DUAL;
16917: ELSE
16918: l_new_serial_txn_temp_id := NULL;