DBA Data[Home] [Help]

APPS.INV_PHY_INV_LOVS dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 2439: SELECT mtl_material_transactions_s.nextval

2435: | NULL, 'No Status entered' |
2436: |-----------------------------------------*/
2437: Mydebug(' Start Processing the Implicit Physical Inventory Xfer ');
2438: /*
2439: SELECT mtl_material_transactions_s.nextval
2440: INTO l_transaction_header_id
2441: FROM dual;
2442: */
2443: Mydebug(' l_transaction_header_id ..'||l_transaction_header_id);

Line 2509: ,mtl_material_transactions_s.nextval

2505: ,transaction_batch_id
2506: ,transaction_batch_seq
2507: )
2508: VALUES ( l_transaction_header_id
2509: ,mtl_material_transactions_s.nextval
2510: ,l_txnprocmode
2511: ,sysdate
2512: ,l_last_updated_by
2513: ,sysdate

Line 2536: ,mtl_material_transactions_s.currval

2532: ,i.xfr_subinventory_name
2533: ,i.to_locator
2534: ,l_process_flag
2535: ,i.parent_lpn_id
2536: ,mtl_material_transactions_s.currval
2537: ,mtl_material_transactions_s.currval
2538: );
2539:
2540: END IF;

Line 2537: ,mtl_material_transactions_s.currval

2533: ,i.to_locator
2534: ,l_process_flag
2535: ,i.parent_lpn_id
2536: ,mtl_material_transactions_s.currval
2537: ,mtl_material_transactions_s.currval
2538: );
2539:
2540: END IF;
2541: