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.

VIEW: APPS.PJM_PROJECT_ONHAND_V

Source

View Text - Preformatted


SELECT LOC.PROJECT_ID , LOC.TASK_ID , QTY.ORGANIZATION_ID , ORG.NAME , QTY.INVENTORY_ITEM_ID , ITEM.CONCATENATED_SEGMENTS , ITEM.DESCRIPTION , QTY.SUBINVENTORY_CODE , PHYLOC.CONCATENATED_SEGMENTS , PRIMARY_UOM_CODE , NVL( SUM( QTY.TRANSACTION_QUANTITY ) , 0 ) FROM MTL_ONHAND_QUANTITIES_DETAIL QTY , MTL_ITEM_LOCATIONS LOC , MTL_SYSTEM_ITEMS_KFV ITEM , HR_ALL_ORGANIZATION_UNITS_TL ORG , MTL_ITEM_LOCATIONS_KFV PHYLOC WHERE LOC.ORGANIZATION_ID = QTY.ORGANIZATION_ID AND LOC.INVENTORY_LOCATION_ID = QTY.LOCATOR_ID AND ITEM.INVENTORY_ITEM_ID = QTY.INVENTORY_ITEM_ID AND ITEM.ORGANIZATION_ID = QTY.ORGANIZATION_ID AND ORG.ORGANIZATION_ID = QTY.ORGANIZATION_ID AND ORG.LANGUAGE = USERENV('LANG') AND PHYLOC.ORGANIZATION_ID = LOC.ORGANIZATION_ID AND PHYLOC.INVENTORY_LOCATION_ID = NVL( LOC.PHYSICAL_LOCATION_ID , LOC.INVENTORY_LOCATION_ID ) GROUP BY LOC.PROJECT_ID , LOC.TASK_ID , QTY.ORGANIZATION_ID , ORG.NAME , QTY.INVENTORY_ITEM_ID , ITEM.CONCATENATED_SEGMENTS , ITEM.DESCRIPTION , QTY.SUBINVENTORY_CODE , PHYLOC.CONCATENATED_SEGMENTS , PRIMARY_UOM_CODE

View Text - HTML Formatted

SELECT LOC.PROJECT_ID
, LOC.TASK_ID
, QTY.ORGANIZATION_ID
, ORG.NAME
, QTY.INVENTORY_ITEM_ID
, ITEM.CONCATENATED_SEGMENTS
, ITEM.DESCRIPTION
, QTY.SUBINVENTORY_CODE
, PHYLOC.CONCATENATED_SEGMENTS
, PRIMARY_UOM_CODE
, NVL( SUM( QTY.TRANSACTION_QUANTITY )
, 0 )
FROM MTL_ONHAND_QUANTITIES_DETAIL QTY
, MTL_ITEM_LOCATIONS LOC
, MTL_SYSTEM_ITEMS_KFV ITEM
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, MTL_ITEM_LOCATIONS_KFV PHYLOC
WHERE LOC.ORGANIZATION_ID = QTY.ORGANIZATION_ID
AND LOC.INVENTORY_LOCATION_ID = QTY.LOCATOR_ID
AND ITEM.INVENTORY_ITEM_ID = QTY.INVENTORY_ITEM_ID
AND ITEM.ORGANIZATION_ID = QTY.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = QTY.ORGANIZATION_ID
AND ORG.LANGUAGE = USERENV('LANG')
AND PHYLOC.ORGANIZATION_ID = LOC.ORGANIZATION_ID
AND PHYLOC.INVENTORY_LOCATION_ID = NVL( LOC.PHYSICAL_LOCATION_ID
, LOC.INVENTORY_LOCATION_ID ) GROUP BY LOC.PROJECT_ID
, LOC.TASK_ID
, QTY.ORGANIZATION_ID
, ORG.NAME
, QTY.INVENTORY_ITEM_ID
, ITEM.CONCATENATED_SEGMENTS
, ITEM.DESCRIPTION
, QTY.SUBINVENTORY_CODE
, PHYLOC.CONCATENATED_SEGMENTS
, PRIMARY_UOM_CODE