APPS.INV_LOC_WMS_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 19: FROM mtl_material_transactions_temp

15: l_dummy number;
16: l_ret_status boolean := true ;
17: BEGIN
18: SELECT count(1) into l_dummy
19: FROM mtl_material_transactions_temp
20: WHERE organization_id = p_org_id
21: AND locator_id = p_loc_id
22: AND ROWNUM =1 ;
23: IF (l_dummy > 0 )THEN

Line 28: FROM mtl_material_transactions_temp

24: l_ret_status := FALSE;
25: END IF;
26: IF l_ret_status THEN
27: SELECT count(1) into l_dummy
28: FROM mtl_material_transactions_temp
29: WHERE transfer_organization = p_org_id
30: AND transfer_to_location = p_loc_id
31: AND ROWNUM =1 ;
32: IF (l_dummy > 0 )THEN

Line 2622: /* Check if the locator is present in MTL_MATERIAL_TRANSACTIONS_TEMP

2618: WHEN NO_DATA_FOUND THEN
2619: NULL;
2620: END;
2621:
2622: /* Check if the locator is present in MTL_MATERIAL_TRANSACTIONS_TEMP
2623: If the LOCATOR_ID exists then error out*/
2624: /* Added the condition after OR clause in the following SQL to handle the case
2625: when a locator exists in the tranfer_to_location field of the MMTT record
2626: as a part of the Bug Fix:2004798*/

Line 2633: FROM mtl_material_transactions_temp

2629: INTO l_chk_flag
2630: FROM DUAL
2631: WHERE EXISTS(
2632: SELECT 1
2633: FROM mtl_material_transactions_temp
2634: WHERE (locator_id = l_inventory_location_id
2635: AND organization_id = l_organization_id)
2636: OR(transfer_to_location = l_inventory_location_id
2637: AND NVL(transfer_organization, organization_id) = l_organization_id));