View: ICX_EDM_INV_ONHAND_BAL_V

Product:	ICX - Oracle iProcurement
Description:	Project Inventory Onhand Quantity Balance View
Implementation/DBA Data:	APPS.ICX_EDM_INV_ONHAND_BAL_V

View Text

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

Columns