APPS.WMS_CONSOLIDATION_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1776: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP

1772: AND ROWNUM = 1;
1773: IF (g_trace_on = 1) THEN mydebug('l_item_id ' || l_item_id); END IF;
1774:
1775:
1776: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
1777: (TRANSACTION_HEADER_ID,
1778: TRANSACTION_TEMP_ID,
1779: PROCESS_FLAG,
1780: transaction_status,

Line 2476: mtl_material_transactions_temp mmtt,

2472: AND NOT exists
2473: (
2474: SELECT 1
2475: FROM
2476: mtl_material_transactions_temp mmtt,
2477: wsh_delivery_details wdd1,
2478: wsh_delivery_assignments_v wda2
2479: WHERE wda2.delivery_id = p_delivery_id
2480: AND wda2.delivery_detail_id = wdd1.delivery_detail_id

Line 2608: mtl_material_transactions_temp mmtt

2604: SELECT mmtt.transaction_temp_id
2605: INTO l_temp_id
2606: FROM
2607: wms_dispatched_tasks wdt,
2608: mtl_material_transactions_temp mmtt
2609: WHERE mmtt.organization_id = p_org_id
2610: AND mmtt.transfer_lpn_id = p_lpn_id
2611: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
2612: AND ROWNUM = 1;

Line 2748: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP

2744: AND wlpn.outermost_lpn_id = p_lpn_id
2745: AND wlpn.organization_id = p_org_id
2746: AND ROWNUM = 1;
2747:
2748: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
2749: (TRANSACTION_HEADER_ID,
2750: TRANSACTION_TEMP_ID,
2751: PROCESS_FLAG,
2752: transaction_status,