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.AHL_OSP_RCV_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 3149: --jrotich modified cursor to use only mtl_item_locations_kfv for bug 14301820

3145: x_msg_data OUT NOCOPY VARCHAR2)
3146: IS
3147:
3148: -- Cursor to check whether the given locator number is valid or not.
3149: --jrotich modified cursor to use only mtl_item_locations_kfv for bug 14301820
3150: --change done on 09/02/2012
3151: /*cursor modified by jrotich on 11-FEB-2013 for bug 16304850.
3152: This change reverts the performance fix done on 09/02/2012. However,
3153: we will use the entire unique index on organization_id and inventory_location id to improve performance

Line 3160: FROM MTL_ITEM_LOCATIONS_KFV MIL_kfv

3156: CURSOR is_valid_locator (c_org_id NUMBER, c_locator_name VARCHAR2) IS
3157: SELECT MIL.INVENTORY_LOCATION_ID
3158: ,MIL_kfv.CONCATENATED_SEGMENTS
3159: ,MIL.SUBINVENTORY_CODE
3160: FROM MTL_ITEM_LOCATIONS_KFV MIL_kfv
3161: ,MTL_ITEM_LOCATIONS MIL
3162: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID AND
3163: MIL_kfv.ORGANIZATION_ID = MIL.ORGANIZATION_ID AND
3164: MIL_kfv.ORGANIZATION_ID = c_org_id