APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 11508: SELECT mtl_material_transactions_s.NEXTVAL

11504: l_primary_lot_qty := l_lot_rec.quantity;
11505: END IF;
11506:
11507: if l_lot_interface_id is null then
11508: SELECT mtl_material_transactions_s.NEXTVAL
11509: INTO l_lot_Interface_Id
11510: FROM DUAL;
11511: End if;
11512:

Line 11526: SELECT mtl_material_transactions_s.NEXTVAL

11522: )
11523: Loop
11524: -- Generate the serial interface id here
11525: if l_serial_interface_id is null then
11526: SELECT mtl_material_transactions_s.NEXTVAL
11527: INTO l_serial_Interface_Id
11528: FROM DUAL;
11529: End if;
11530:

Line 11589: SELECT mtl_material_transactions_s.NEXTVAL

11585: )
11586: Loop
11587: -- Generate the serial interface id here
11588: if l_serial_interface_id is null then
11589: SELECT mtl_material_transactions_s.NEXTVAL
11590: INTO l_serial_Interface_Id
11591: FROM DUAL;
11592: End if;
11593:

Line 12030: SELECT mtl_material_transactions_s.NEXTVAL

12026: END IF;
12027:
12028: IF (l_mol_mmtt_ctnt_tb(i).lot_number IS NOT NULL) THEN
12029: IF l_lot_interface_id IS NULL THEN
12030: SELECT mtl_material_transactions_s.NEXTVAL
12031: INTO l_lot_interface_id
12032: FROM DUAL;
12033: END IF;
12034:

Line 12184: SELECT mtl_material_transactions_s.NEXTVAL

12180: END IF;
12181:
12182: FOR j IN 1..l_rti_serial_tb(l_rti_index).COUNT LOOP
12183: IF l_serial_interface_id IS NULL THEN
12184: SELECT mtl_material_transactions_s.NEXTVAL
12185: INTO l_serial_Interface_Id
12186: FROM DUAL;
12187: END IF;
12188:

Line 12214: SELECT mtl_material_transactions_s.NEXTVAL

12210: END LOOP;--FOR j IN 1..l_rti_serial_tb(l_rti_index).COUNT LOOP
12211:
12212: IF (l_mol_mmtt_ctnt_tb(i).lot_number IS NOT NULL) THEN
12213: IF l_lot_interface_id IS NULL THEN
12214: SELECT mtl_material_transactions_s.NEXTVAL
12215: INTO l_lot_interface_id
12216: FROM DUAL;
12217: END IF;
12218:

Line 17772: SELECT mtl_material_transactions_s.NEXTVAL

17768: -- l_mtli_rec.transaction_quantity - l_remaining_quantity
17769:
17770: IF (l_mtli_rec.serial_transaction_temp_id IS NOT NULL)
17771: THEN
17772: SELECT mtl_material_transactions_s.NEXTVAL
17773: INTO l_new_serial_txn_temp_id
17774: FROM DUAL;
17775: ELSE
17776: l_new_serial_txn_temp_id := NULL;