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 5472: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq

5468: l_pick_order NUMBER;
5469:
5470: CURSOR c_pick_order IS
5471: SELECT MIN(ABS(NVL(milx.picking_order, -9999) - NVL(mil.picking_order, 9999)))
5472: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq
5473: WHERE mil.inventory_location_id = p_locator_id
5474: AND mil.organization_id = p_organization_id
5475: AND moq.organization_id = p_organization_id
5476: AND moq.inventory_item_id = p_inventory_item_id

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

5532: )
5533: )
5534: )
5535: )
5536: FROM mtl_item_locations mil, mtl_item_locations milx, mtl_onhand_quantities_detail moq
5537: WHERE mil.inventory_location_id = p_locator_id
5538: AND mil.organization_id = p_organization_id
5539: AND moq.organization_id = p_organization_id
5540: AND moq.inventory_item_id = p_inventory_item_id

Line 5837: FROM mtl_item_locations

5833: FUNCTION getnumemptylocators(p_organization_id IN NUMBER, p_subinventory_code IN VARCHAR2)
5834: RETURN NUMBER IS
5835: CURSOR c_locations IS
5836: SELECT COUNT(inventory_location_id)
5837: FROM mtl_item_locations
5838: WHERE organization_id = p_organization_id
5839: AND subinventory_code = p_subinventory_code
5840: AND empty_flag = 'Y';
5841: