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_COPY_ORGANIZATION_REPORT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 2618: , MTL_ITEM_LOCATIONS_KFV kfv1

2614: )
2615: IS
2616: SELECT kfv1.CONCATENATED_SEGMENTS
2617: FROM MTL_ITEM_LOCATIONS loc1
2618: , MTL_ITEM_LOCATIONS_KFV kfv1
2619: WHERE kfv1.ORGANIZATION_ID=loc1.ORGANIZATION_ID
2620: AND kfv1.INVENTORY_LOCATION_ID=loc1.INVENTORY_LOCATION_ID
2621: AND loc1.ORGANIZATION_ID=p_model_org_id
2622: AND NOT EXISTS

Line 2625: , MTL_ITEM_LOCATIONS_KFV kfv2

2621: AND loc1.ORGANIZATION_ID=p_model_org_id
2622: AND NOT EXISTS
2623: ( SELECT 'x'
2624: FROM MTL_ITEM_LOCATIONS loc2
2625: , MTL_ITEM_LOCATIONS_KFV kfv2
2626: WHERE loc2.ORGANIZATION_ID=p_organization_id
2627: AND kfv2.INVENTORY_LOCATION_ID=loc2.INVENTORY_LOCATION_ID
2628: AND kfv2.ORGANIZATION_ID=loc2.ORGANIZATION_ID
2629: AND kfv2.CONCATENATED_SEGMENTS=kfv1.CONCATENATED_SEGMENTS