View: POS_MTL_ONHAND_REV_KFV

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.POS_MTL_ONHAND_REV_KFV

View Text

SELECT A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, B.CONCATENATED_SEGMENTS ITEM
, A.REVISION
, SUM(A.TRANSACTION_QUANTITY) TOTAL_QOH
, B.DESCRIPTION ITEM_DESCRIPTION
, B.PRIMARY_UOM_CODE
, C.ORGANIZATION_CODE
, D.NAME ORGANIZATION_NAME
, B.ATTRIBUTE14 ITEM_URL
FROM MTL_ONHAND_QUANTITIES A
, MTL_SYSTEM_ITEMS_KFV B
, MTL_PARAMETERS C
, HR_ORGANIZATION_UNITS D
WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND A.ORGANIZATION_ID = C.ORGANIZATION_ID
AND A.ORGANIZATION_ID = D.ORGANIZATION_ID GROUP BY A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, B.CONCATENATED_SEGMENTS
, A.REVISION
, B.DESCRIPTION
, B.PRIMARY_UOM_CODE
, C.ORGANIZATION_CODE
, D.NAME
, B.ATTRIBUTE14

Columns