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.ICX_EDM_INV_ONHAND_BAL_V

Source

View Text - Preformatted


SELECT LOC.PROJECT_ID , LOC.TASK_ID , PROJ.PROJECT_NUMBER , TASK.TASK_NUMBER , ORG.NAME ORGANIZATION_NAME , PARA.ORGANIZATION_CODE , ITEM.CONCATENATED_SEGMENTS ITEM_NUMBER , ITEM.DESCRIPTION ITEM_DESCRIPTION , ITEM.ATTRIBUTE14 ITEM_URL , QTY.SUBINVENTORY_CODE , PHYLOC.CONCATENATED_SEGMENTS , NVL(SUM(QTY.TRANSACTION_QUANTITY), 0) TOTAL_QUANTITY , ITEM.PRIMARY_UOM_CODE , QTY.ORGANIZATION_ID , QTY.INVENTORY_ITEM_ID FROM MTL_ONHAND_QUANTITIES QTY , MTL_ITEM_LOCATIONS LOC , MTL_SYSTEM_ITEMS_KFV ITEM , MTL_SECONDARY_INVENTORIES INV , HR_ORGANIZATION_UNITS ORG , MTL_PARAMETERS PARA , MTL_ITEM_LOCATIONS_KFV PHYLOC , PJM_PROJECTS_V PROJ , PA_TASKS TASK WHERE INV.SECONDARY_INVENTORY_NAME = QTY.SUBINVENTORY_CODE AND INV.ORGANIZATION_ID = QTY.ORGANIZATION_ID AND 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 PARA.ORGANIZATION_ID = QTY.ORGANIZATION_ID AND PHYLOC.ORGANIZATION_ID = LOC.ORGANIZATION_ID AND PHYLOC.INVENTORY_LOCATION_ID = NVL(LOC.PHYSICAL_LOCATION_ID, LOC.INVENTORY_LOCATION_ID) AND PROJ.PROJECT_ID = LOC.PROJECT_ID AND TASK.TASK_ID (+) = LOC.TASK_ID GROUP BY PROJ.PROJECT_NUMBER , LOC.PROJECT_ID , TASK.TASK_NUMBER , LOC.TASK_ID , ORG.NAME , PARA.ORGANIZATION_CODE , ITEM.CONCATENATED_SEGMENTS , ITEM.DESCRIPTION , ITEM.ATTRIBUTE14 , QTY.SUBINVENTORY_CODE , PHYLOC.CONCATENATED_SEGMENTS , ITEM.PRIMARY_UOM_CODE , QTY.ORGANIZATION_ID , QTY.INVENTORY_ITEM_ID

View Text - HTML Formatted

SELECT LOC.PROJECT_ID
, LOC.TASK_ID
, PROJ.PROJECT_NUMBER
, TASK.TASK_NUMBER
, ORG.NAME ORGANIZATION_NAME
, PARA.ORGANIZATION_CODE
, ITEM.CONCATENATED_SEGMENTS ITEM_NUMBER
, ITEM.DESCRIPTION ITEM_DESCRIPTION
, ITEM.ATTRIBUTE14 ITEM_URL
, QTY.SUBINVENTORY_CODE
, PHYLOC.CONCATENATED_SEGMENTS
, NVL(SUM(QTY.TRANSACTION_QUANTITY)
, 0) TOTAL_QUANTITY
, ITEM.PRIMARY_UOM_CODE
, QTY.ORGANIZATION_ID
, QTY.INVENTORY_ITEM_ID
FROM MTL_ONHAND_QUANTITIES QTY
, MTL_ITEM_LOCATIONS LOC
, MTL_SYSTEM_ITEMS_KFV ITEM
, MTL_SECONDARY_INVENTORIES INV
, HR_ORGANIZATION_UNITS ORG
, MTL_PARAMETERS PARA
, MTL_ITEM_LOCATIONS_KFV PHYLOC
, PJM_PROJECTS_V PROJ
, PA_TASKS TASK
WHERE INV.SECONDARY_INVENTORY_NAME = QTY.SUBINVENTORY_CODE
AND INV.ORGANIZATION_ID = QTY.ORGANIZATION_ID
AND 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 PARA.ORGANIZATION_ID = QTY.ORGANIZATION_ID
AND PHYLOC.ORGANIZATION_ID = LOC.ORGANIZATION_ID
AND PHYLOC.INVENTORY_LOCATION_ID = NVL(LOC.PHYSICAL_LOCATION_ID
, LOC.INVENTORY_LOCATION_ID)
AND PROJ.PROJECT_ID = LOC.PROJECT_ID
AND TASK.TASK_ID (+) = LOC.TASK_ID GROUP BY PROJ.PROJECT_NUMBER
, LOC.PROJECT_ID
, TASK.TASK_NUMBER
, LOC.TASK_ID
, ORG.NAME
, PARA.ORGANIZATION_CODE
, ITEM.CONCATENATED_SEGMENTS
, ITEM.DESCRIPTION
, ITEM.ATTRIBUTE14
, QTY.SUBINVENTORY_CODE
, PHYLOC.CONCATENATED_SEGMENTS
, ITEM.PRIMARY_UOM_CODE
, QTY.ORGANIZATION_ID
, QTY.INVENTORY_ITEM_ID