DBA Data[Home] [Help]

APPS.INV_PHY_INV_LOVS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 2306: l_transaction_reference mtl_material_transactions_temp.transaction_reference%TYPE;

2302: ORDER BY mpa_sys.outermost_lpn_id, mpa_sys.parent_lpn_id,mpa_xfr.subinventory_name,mpa_sys.inventory_item_id,mpa_sys.lot_number, mpa_xfr.adjustment_id;
2303:
2304: l_transaction_header_id NUMBER := p_txn_header_id;
2305: l_transaction_temp_id NUMBER;
2306: l_transaction_reference mtl_material_transactions_temp.transaction_reference%TYPE;
2307: l_uom_code mtl_system_items.primary_uom_code%TYPE;
2308: l_sec_uom_code mtl_system_items.secondary_uom_code%TYPE;
2309: l_debug NUMBER := Nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2310: l_proc_name VARCHAR2(20) := 'PHY_INV_SUB_XFER ';

Line 2476: INSERT INTO mtl_material_transactions_temp

2472: RETURN;
2473: END IF;
2474: mydebug(' Inserting MMTT with l_transaction_header_id : '||l_transaction_header_id ||' content_lpn_id : '||i.parent_lpn_id);
2475:
2476: INSERT INTO mtl_material_transactions_temp
2477: (transaction_header_id
2478: ,transaction_temp_id
2479: ,transaction_mode
2480: ,last_update_date