DBA Data[Home] [Help]

APPS.WSM_SERIAL_SUPPORT_GRP dependencies on MTL_MATERIAL_TRANSACTIONS

Line 232: FROM MTL_MATERIAL_TRANSACTIONS MMT

228: l_temp_id NUMBER;
229:
230: cursor c_mmt_txn is
231: SELECT TRANSACTION_ID
232: FROM MTL_MATERIAL_TRANSACTIONS MMT
233: WHERE MMT.organization_id = p_organization_id
234: AND MMT.move_transaction_id IN (l_move_txn_id,l_scrap_txn_id)
235: AND MMT.transaction_source_id = p_wip_entity_id
236: AND MMT.subinventory_code IS NOT NULL

Line 334: /*SELECT mtl_material_transactions_s.nextval

330: end if;
331:
332: -- get a txn header id..
333: -- No will be passed...
334: /*SELECT mtl_material_transactions_s.nextval
335: into p_mtl_txn_hdr_id
336: from dual;
337: */
338:

Line 341: SELECT mtl_material_transactions_s.nextval

337: */
338:
339: /* Have to be passed....
340: if p_move_txn_type = wip_constants.RET_TXN then
341: SELECT mtl_material_transactions_s.nextval
342: into p_compl_txn_id
343: from dual;
344: end if;
345: */

Line 392: select mtl_material_transactions_s.nextval

388:
389: for l_mmt_rec in c_mmt_txn loop
390:
391: l_stmt_num := 60;
392: select mtl_material_transactions_s.nextval
393: into l_temp_id
394: from dual;
395:
396: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 409: INSERT INTO mtl_material_transactions_temp

405: END IF;
406:
407: l_stmt_num := 70;
408: -- Insert into MMTT
409: INSERT INTO mtl_material_transactions_temp
410: (
411: TRANSACTION_HEADER_ID,
412: TRANSACTION_TEMP_ID,
413: SOURCE_CODE,

Line 541: FROM MTL_MATERIAL_TRANSACTIONS MMT

537: MMT.SOURCE_TASK_ID,
538: MMT.PROJECT_ID,
539: MMT.TASK_ID,
540: p_move_txn_id --Bug 5207917
541: FROM MTL_MATERIAL_TRANSACTIONS MMT
542: WHERE TRANSACTION_ID = l_mmt_rec.transaction_id;
543:
544: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
545: l_msg_tokens.delete;

Line 565: select mtl_material_transactions_s.nextval

561:
562: l_lot_controlled := 1;
563: if l_lot_txn_rec.serial_transaction_id is not null then
564: l_stmt_num := 100;
565: select mtl_material_transactions_s.nextval
566: into l_serial_txn_id
567: from dual;
568: else
569: l_stmt_num := 110;