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_ONHAND_QUANTITIES_DETAIL

Line 504: FROM mtl_onhand_quantities_detail moq

500: IF ( P_Transfer_Mode = G_TXFR_MODE_ALL_ITEMS ) THEN
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

Line 516: FROM mtl_onhand_quantities_detail moq

512: ELSIF ( P_Transfer_Mode = G_TXFR_MODE_CATEGORY ) THEN
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

Line 654: FROM mtl_onhand_quantities_detail moq

650: , moq.locator_id
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