APPS.WMS_CONSOLIDATION_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1781: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP

1777: AND ROWNUM = 1;
1778: IF (g_trace_on = 1) THEN mydebug('l_item_id ' || l_item_id); END IF;
1779:
1780:
1781: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
1782: (TRANSACTION_HEADER_ID,
1783: TRANSACTION_TEMP_ID,
1784: PROCESS_FLAG,
1785: transaction_status,

Line 2481: mtl_material_transactions_temp mmtt,

2477: AND NOT exists
2478: (
2479: SELECT 1
2480: FROM
2481: mtl_material_transactions_temp mmtt,
2482: wsh_delivery_details wdd1,
2483: wsh_delivery_assignments_v wda2
2484: WHERE wda2.delivery_id = p_delivery_id
2485: AND wda2.delivery_detail_id = wdd1.delivery_detail_id

Line 2616: mtl_material_transactions_temp mmtt

2612: SELECT mmtt.transaction_temp_id
2613: INTO l_temp_id
2614: FROM
2615: wms_dispatched_tasks wdt,
2616: mtl_material_transactions_temp mmtt
2617: WHERE mmtt.organization_id = p_org_id
2618: AND mmtt.transfer_lpn_id = p_lpn_id
2619: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
2620: AND ROWNUM = 1;

Line 2842: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP

2838: AND wlpn.outermost_lpn_id = p_lpn_id
2839: AND wlpn.organization_id = p_org_id
2840: AND ROWNUM = 1;
2841:
2842: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
2843: (TRANSACTION_HEADER_ID,
2844: TRANSACTION_TEMP_ID,
2845: PROCESS_FLAG,
2846: transaction_status,