APPS.WMS_PUTAWAY_UTILS dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 1035: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

1031:
1032: END LOOP;
1033: l_progress := '300';
1034:
1035: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
1036: INTO l_txn_header_id
1037: FROM dual;
1038:
1039: l_progress := '310';

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

1153:
1154: EXIT WHEN c_all_group_tasks_cursor%NOTFOUND;
1155: l_progress := '130';
1156:
1157: --l_txn_header_id := MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL;
1158:
1159: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
1160: INTO l_txn_header_id
1161: FROM dual;

Line 1159: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

1155: l_progress := '130';
1156:
1157: --l_txn_header_id := MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL;
1158:
1159: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
1160: INTO l_txn_header_id
1161: FROM dual;
1162: l_progress := '140';
1163:

Line 7442: SELECT mtl_material_transactions_s.NEXTVAL

7438: END IF;
7439:
7440: -- Get Transaction header id.
7441:
7442: SELECT mtl_material_transactions_s.NEXTVAL
7443: INTO l_trx_header_id
7444: FROM dual;
7445:
7446:

Line 9722: SELECT mtl_material_transactions_s.NEXTVAL

9718: l_progress := '240';
9719:
9720: -- create MMTT records for each loose item, each inner LPN
9721: -- Group them into same header, and then call inventory TM
9722: SELECT mtl_material_transactions_s.NEXTVAL
9723: INTO l_hdr_id
9724: FROM dual;
9725:
9726: l_progress := '250';

Line 11150: SELECT mtl_material_transactions_s.NEXTVAL

11146: END;
11147:
11148: IF (p_lpn_context IN (G_LPN_CONTEXT_INV, G_LPN_CONTEXT_WIP)) THEN
11149:
11150: SELECT mtl_material_transactions_s.NEXTVAL
11151: INTO l_new_txn_header_id
11152: FROM DUAL;
11153:
11154: --For an item drop of an Inventory/WIP LPN with quantity

Line 11381: SELECT mtl_material_transactions_s.NEXTVAL

11377:
11378: l_progress := '170';
11379:
11380: IF (l_disc = 'Y' OR p_entire_lpn = 'N') THEN
11381: SELECT mtl_material_transactions_s.NEXTVAL
11382: INTO l_dummy_temp_id
11383: FROM dual;
11384: END IF;
11385: