eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOC_WMS_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

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

2522: WHEN NO_DATA_FOUND THEN
2523: NULL;
2524: END;
2525:
2526: /* Check if the locator is present in MTL_MATERIAL_TRANSACTIONS_TEMP
2527: If the LOCATOR_ID exists then error out*/
2528: /* Added the condition after OR clause in the following SQL to handle the case
2529: when a locator exists in the tranfer_to_location field of the MMTT record
2530: as a part of the Bug Fix:2004798*/

Line 2537: FROM mtl_material_transactions_temp

2533: INTO l_chk_flag
2534: FROM DUAL
2535: WHERE EXISTS(
2536: SELECT 1
2537: FROM mtl_material_transactions_temp
2538: WHERE (locator_id = l_inventory_location_id
2539: AND organization_id = l_organization_id)
2540: OR(transfer_to_location = l_inventory_location_id
2541: AND NVL(transfer_organization, organization_id) = l_organization_id));