DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 3970: SELECT mtl_material_transactions_s.NEXTVAL

3966: IF (l_debug =1) THEN
3967: mydebug('RCV LPN: Always generate new txn header id');
3968: END IF;
3969:
3970: SELECT mtl_material_transactions_s.NEXTVAL
3971: INTO l_txn_header_id
3972: FROM DUAL;
3973: ELSE
3974: IF (l_debug =1) THEN

Line 4239: SELECT mtl_material_transactions_s.NEXTVAL

4235: AND lot_number = p_lot;
4236: END IF;
4237: -- Need to get the next value for serial temp id
4238: IF l_ser_seq IS NULL THEN
4239: SELECT mtl_material_transactions_s.NEXTVAL
4240: INTO l_ser_seq
4241: FROM DUAL;
4242: END IF;
4243: /* bug12607020 */

Line 8638: SELECT mtl_material_transactions_s.NEXTVAL

8634: mydebug('SECONDARY_UOM_CODE: => ' || v_mo_line.SECONDARY_UOM_CODE);
8635: END IF;
8636:
8637: -- Get a new transaction header id from the sequence
8638: SELECT mtl_material_transactions_s.NEXTVAL
8639: INTO l_txn_header_id
8640: FROM DUAL;
8641:
8642: IF (l_debug = 1) THEN