VIEW: APPS.POS_MTL_ONHAND_ITEMS_KFV

Source

View Text - Preformatted

SELECT OAD.ORGANIZATION_ID, OAD.INVENTORY_ITEM_ID, MSI.CONCATENATED_SEGMENTS ITEM, SUM(OAD.TRANSACTION_QUANTITY) TOTAL_QOH, MSI.DESCRIPTION ITEM_DESCRIPTION, MSI.PRIMARY_UOM_CODE, MP.ORGANIZATION_CODE, HOU.NAME ORGANIZATION_NAME, MSI.ATTRIBUTE14 ITEM_URL FROM MTL_ONHAND_QUANTITIES OAD, MTL_SYSTEM_ITEMS_KFV MSI, MTL_PARAMETERS MP, HR_ALL_ORGANIZATION_UNITS_TL HOU WHERE OAD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND OAD.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND OAD.ORGANIZATION_ID = MP.ORGANIZATION_ID AND OAD.ORGANIZATION_ID = HOU.ORGANIZATION_ID (+) AND HOU.LANGUAGE (+) = USERENV('LANG') GROUP BY OAD.ORGANIZATION_ID, OAD.INVENTORY_ITEM_ID, MSI.CONCATENATED_SEGMENTS, MSI.DESCRIPTION, MSI.PRIMARY_UOM_CODE, MP.ORGANIZATION_CODE, HOU.NAME, MSI.ATTRIBUTE14

View Text - HTML Formatted

SELECT OAD.ORGANIZATION_ID
, OAD.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM
, SUM(OAD.TRANSACTION_QUANTITY) TOTAL_QOH
, MSI.DESCRIPTION ITEM_DESCRIPTION
, MSI.PRIMARY_UOM_CODE
, MP.ORGANIZATION_CODE
, HOU.NAME ORGANIZATION_NAME
, MSI.ATTRIBUTE14 ITEM_URL
FROM MTL_ONHAND_QUANTITIES OAD
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS_TL HOU
WHERE OAD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND OAD.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND OAD.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND OAD.ORGANIZATION_ID = HOU.ORGANIZATION_ID (+)
AND HOU.LANGUAGE (+) = USERENV('LANG') GROUP BY OAD.ORGANIZATION_ID
, OAD.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, MSI.PRIMARY_UOM_CODE
, MP.ORGANIZATION_CODE
, HOU.NAME
, MSI.ATTRIBUTE14