APPS.WMS_PUTAWAY_UTILS dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 536: --l_txn_header_id := MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL;

532:
533: EXIT WHEN c_all_group_tasks_cursor%NOTFOUND;
534: l_progress := '130';
535:
536: --l_txn_header_id := MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL;
537:
538: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
539: INTO l_txn_header_id
540: FROM dual;

Line 538: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

534: l_progress := '130';
535:
536: --l_txn_header_id := MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL;
537:
538: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
539: INTO l_txn_header_id
540: FROM dual;
541: l_progress := '140';
542:

Line 6580: SELECT mtl_material_transactions_s.NEXTVAL

6576: END IF;
6577:
6578: -- Get Transaction header id.
6579:
6580: SELECT mtl_material_transactions_s.NEXTVAL
6581: INTO l_trx_header_id
6582: FROM dual;
6583:
6584:

Line 8857: SELECT mtl_material_transactions_s.NEXTVAL

8853: l_progress := '240';
8854:
8855: -- create MMTT records for each loose item, each inner LPN
8856: -- Group them into same header, and then call inventory TM
8857: SELECT mtl_material_transactions_s.NEXTVAL
8858: INTO l_hdr_id
8859: FROM dual;
8860:
8861: l_progress := '250';

Line 10255: SELECT mtl_material_transactions_s.NEXTVAL

10251: END;
10252:
10253: IF (p_lpn_context IN (G_LPN_CONTEXT_INV, G_LPN_CONTEXT_WIP)) THEN
10254:
10255: SELECT mtl_material_transactions_s.NEXTVAL
10256: INTO l_new_txn_header_id
10257: FROM DUAL;
10258:
10259: --For an item drop of an Inventory/WIP LPN with quantity

Line 10484: SELECT mtl_material_transactions_s.NEXTVAL

10480:
10481: l_progress := '170';
10482:
10483: IF (l_disc = 'Y' OR p_entire_lpn = 'N') THEN
10484: SELECT mtl_material_transactions_s.NEXTVAL
10485: INTO l_dummy_temp_id
10486: FROM dual;
10487: END IF;
10488: