APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1897: DELETE mtl_material_transactions_temp mmtt

1893: AND organization_id = p_organization_id
1894: AND transfer_lpn_id = p_outermost_lpn_id;
1895: IF (l_debug = 1) THEN debug('DELETED WDT FOR LPN: ' || p_outermost_lpn_id,'LPN_SUBMIT'); END IF;
1896:
1897: DELETE mtl_material_transactions_temp mmtt
1898: WHERE wms_task_type = 7
1899: AND organization_id = p_organization_id
1900: AND content_lpn_id = p_outermost_lpn_id;
1901: IF (l_debug = 1) THEN debug('DELETED WDT FOR LPN: ' || p_outermost_lpn_id,'LPN_SUBMIT'); END IF;

Line 4172: DELETE FROM mtl_material_transactions_temp

4168: -- delete the record from the temp table
4169:
4170: -- bug 2760062
4171:
4172: DELETE FROM mtl_material_transactions_temp
4173: WHERE wms_task_type = 7
4174: AND organization_id = p_organization_id
4175: AND content_lpn_id IN
4176: (SELECT outermost_lpn_id

Line 4210: DELETE FROM mtl_material_transactions_temp

4206: -- delete the record from the temp table
4207:
4208: -- bug 2760062
4209:
4210: DELETE FROM mtl_material_transactions_temp
4211: WHERE wms_task_type = 7
4212: AND organization_id = p_organization_id
4213: AND content_lpn_id IN
4214: (SELECT outermost_lpn_id

Line 4560: DELETE FROM mtl_material_transactions_temp

4556: -- delete the records from the temp table after ship confirm
4557:
4558: -- bug 2760062
4559:
4560: DELETE FROM mtl_material_transactions_temp
4561: WHERE wms_task_type = 7
4562: AND organization_id = p_organization_id
4563: AND content_lpn_id IN
4564: (SELECT outermost_lpn_id

Line 4765: DELETE FROM mtl_material_transactions_temp

4761: if (p_trip_id <> 0 ) THEN
4762:
4763: -- bug 2760062
4764:
4765: DELETE FROM mtl_material_transactions_temp
4766: WHERE wms_task_type = 7
4767: AND organization_id = p_organization_id
4768: AND content_lpn_id IN
4769: (SELECT outermost_lpn_id

Line 4782: DELETE FROM mtl_material_transactions_temp

4778: ELSE --correspndong if: p_trip_id <> 0
4779:
4780: -- bug 2760062
4781:
4782: DELETE FROM mtl_material_transactions_temp
4783: WHERE wms_task_type = 7
4784: AND organization_id = p_organization_id
4785: AND content_lpn_id IN
4786: (SELECT outermost_lpn_id

Line 5527: DELETE FROM mtl_material_transactions_temp

5523: -- before the load/unload stage
5524: -- Removed the call to container_nesting
5525:
5526: --Clean up data for unloading
5527: DELETE FROM mtl_material_transactions_temp
5528: WHERE wms_task_type = 7
5529: AND organization_id = p_organization_id
5530: AND content_lpn_id = p_outermost_lpn_id;
5531: