APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1957: DELETE mtl_material_transactions_temp mmtt

1953: AND organization_id = p_organization_id
1954: AND transfer_lpn_id = p_outermost_lpn_id;
1955: IF (l_debug = 1) THEN debug('DELETED WDT FOR LPN: ' || p_outermost_lpn_id,'LPN_SUBMIT'); END IF;
1956:
1957: DELETE mtl_material_transactions_temp mmtt
1958: WHERE wms_task_type = 7
1959: AND organization_id = p_organization_id
1960: AND content_lpn_id = p_outermost_lpn_id;
1961: IF (l_debug = 1) THEN debug('DELETED WDT FOR LPN: ' || p_outermost_lpn_id,'LPN_SUBMIT'); END IF;

Line 4332: DELETE FROM mtl_material_transactions_temp

4328: -- delete the record from the temp table
4329:
4330: -- bug 2760062
4331:
4332: DELETE FROM mtl_material_transactions_temp
4333: WHERE wms_task_type = 7
4334: AND organization_id = p_organization_id
4335: AND content_lpn_id IN
4336: (SELECT outermost_lpn_id

Line 4370: DELETE FROM mtl_material_transactions_temp

4366: -- delete the record from the temp table
4367:
4368: -- bug 2760062
4369:
4370: DELETE FROM mtl_material_transactions_temp
4371: WHERE wms_task_type = 7
4372: AND organization_id = p_organization_id
4373: AND content_lpn_id IN
4374: (SELECT outermost_lpn_id

Line 4720: DELETE FROM mtl_material_transactions_temp

4716: -- delete the records from the temp table after ship confirm
4717:
4718: -- bug 2760062
4719:
4720: DELETE FROM mtl_material_transactions_temp
4721: WHERE wms_task_type = 7
4722: AND organization_id = p_organization_id
4723: AND content_lpn_id IN
4724: (SELECT outermost_lpn_id

Line 4925: DELETE FROM mtl_material_transactions_temp

4921: if (p_trip_id <> 0 ) THEN
4922:
4923: -- bug 2760062
4924:
4925: DELETE FROM mtl_material_transactions_temp
4926: WHERE wms_task_type = 7
4927: AND organization_id = p_organization_id
4928: AND content_lpn_id IN
4929: (SELECT outermost_lpn_id

Line 4942: DELETE FROM mtl_material_transactions_temp

4938: ELSE --correspndong if: p_trip_id <> 0
4939:
4940: -- bug 2760062
4941:
4942: DELETE FROM mtl_material_transactions_temp
4943: WHERE wms_task_type = 7
4944: AND organization_id = p_organization_id
4945: AND content_lpn_id IN
4946: (SELECT outermost_lpn_id

Line 5704: DELETE FROM mtl_material_transactions_temp

5700: -- before the load/unload stage
5701: -- Removed the call to container_nesting
5702:
5703: --Clean up data for unloading
5704: DELETE FROM mtl_material_transactions_temp
5705: WHERE wms_task_type = 7
5706: AND organization_id = p_organization_id
5707: AND content_lpn_id = p_outermost_lpn_id;
5708: