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

Line 505: , mtl_item_locations mil

501:
502: OPEN c FOR
503: SELECT DISTINCT moq.inventory_item_id
504: FROM mtl_onhand_quantities_detail moq
505: , mtl_item_locations mil
506: WHERE moq.organization_id = P_Organization_ID
507: AND mil.organization_id = moq.organization_id
508: AND mil.inventory_location_id = moq.locator_id
509: AND mil.project_id = P_From_Project_ID

Line 517: , mtl_item_locations mil

513:
514: OPEN c FOR
515: SELECT DISTINCT moq.inventory_item_id
516: FROM mtl_onhand_quantities_detail moq
517: , mtl_item_locations mil
518: , mtl_item_categories mic
519: WHERE mic.organization_id = P_Organization_ID
520: AND mic.category_set_id = P_Category_Set_ID
521: AND mic.category_id = P_Category_ID

Line 655: , mtl_item_locations mil

651: , moq.lot_number
652: , moq.revision
653: , (-1) * sum(moq.transaction_quantity) txn_quantity
654: FROM mtl_onhand_quantities_detail moq
655: , mtl_item_locations mil
656: WHERE moq.organization_id = P_Organization_ID
657: AND moq.inventory_item_id = P_Item_ID
658: AND mil.organization_id = moq.organization_id
659: AND mil.inventory_location_id = moq.locator_id