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.WMS_PARAMETER_PVT dependencies on MTL_ITEM_LOCATIONS

Line 5458: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq

5454: l_pick_order NUMBER;
5455:
5456: CURSOR c_pick_order IS
5457: SELECT MIN(ABS(NVL(milx.picking_order, -9999) - NVL(mil.picking_order, 9999)))
5458: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq
5459: WHERE mil.inventory_location_id = p_locator_id
5460: AND mil.organization_id = p_organization_id
5461: AND moq.organization_id = p_organization_id
5462: AND moq.inventory_item_id = p_inventory_item_id

Line 5522: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq

5518: )
5519: )
5520: )
5521: )
5522: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq
5523: WHERE mil.inventory_location_id = p_locator_id
5524: AND mil.organization_id = p_organization_id
5525: AND moq.organization_id = p_organization_id
5526: AND moq.inventory_item_id = p_inventory_item_id

Line 5823: FROM mtl_item_locations

5819: FUNCTION getnumemptylocators(p_organization_id IN NUMBER, p_subinventory_code IN VARCHAR2)
5820: RETURN NUMBER IS
5821: CURSOR c_locations IS
5822: SELECT COUNT(inventory_location_id)
5823: FROM mtl_item_locations
5824: WHERE organization_id = p_organization_id
5825: AND subinventory_code = p_subinventory_code
5826: AND empty_flag = 'Y';
5827: