View: PJM_PROJECT_ONHAND_V

Product:	PJM - Project Manufacturing
Description:	Project inventory onhand quantities for the Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_ONHAND_V

View Text

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

Columns