VIEW: APPS.ICX_MTL_ONHAND_SUB_V

Source

View Text - Preformatted

SELECT A.ORGANIZATION_ID , A.INVENTORY_ITEM_ID , A.SUBINVENTORY_CODE , B.CONCATENATED_SEGMENTS , B.DESCRIPTION ITEM_DESCRIPTION , B.PRIMARY_UOM_CODE , C.ORGANIZATION_CODE , E.NAME ORGANIZATION_NAME , D.AVAILABILITY_TYPE NET , D.RESERVABLE_TYPE RSV , D.INVENTORY_ATP_CODE ATP , D.LOCATOR_TYPE , B.REVISION_QTY_CONTROL_CODE ITEM_REV_CONTROL , B.LOCATION_CONTROL_CODE ITEM_LOCATOR_CONTROL , B.LOT_CONTROL_CODE ITEM_LOT_CONTROL , B.SERIAL_NUMBER_CONTROL_CODE ITEM_SERIAL_CONTROL , SUM(A.TRANSACTION_QUANTITY) TOTAL_QOH FROM MTL_ONHAND_QUANTITIES A , MTL_SYSTEM_ITEMS_KFV B , MTL_PARAMETERS C , MTL_SECONDARY_INVENTORIES D , HR_ORGANIZATION_UNITS E WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND A.SUBINVENTORY_CODE = D.SECONDARY_INVENTORY_NAME AND A.ORGANIZATION_ID = B.ORGANIZATION_ID AND A.ORGANIZATION_ID = C.ORGANIZATION_ID AND A.ORGANIZATION_ID = D.ORGANIZATION_ID AND A.ORGANIZATION_ID = E.ORGANIZATION_ID GROUP BY A.ORGANIZATION_ID , A.INVENTORY_ITEM_ID , A.SUBINVENTORY_CODE , B.CONCATENATED_SEGMENTS , B.DESCRIPTION , B.PRIMARY_UOM_CODE , C.ORGANIZATION_CODE , E.NAME , D.AVAILABILITY_TYPE , D.RESERVABLE_TYPE , D.INVENTORY_ATP_CODE , D.LOCATOR_TYPE , B.REVISION_QTY_CONTROL_CODE , B.LOCATION_CONTROL_CODE , B.LOT_CONTROL_CODE , B.SERIAL_NUMBER_CONTROL_CODE

View Text - HTML Formatted

SELECT A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, A.SUBINVENTORY_CODE
, B.CONCATENATED_SEGMENTS
, B.DESCRIPTION ITEM_DESCRIPTION
, B.PRIMARY_UOM_CODE
, C.ORGANIZATION_CODE
, E.NAME ORGANIZATION_NAME
, D.AVAILABILITY_TYPE NET
, D.RESERVABLE_TYPE RSV
, D.INVENTORY_ATP_CODE ATP
, D.LOCATOR_TYPE
, B.REVISION_QTY_CONTROL_CODE ITEM_REV_CONTROL
, B.LOCATION_CONTROL_CODE ITEM_LOCATOR_CONTROL
, B.LOT_CONTROL_CODE ITEM_LOT_CONTROL
, B.SERIAL_NUMBER_CONTROL_CODE ITEM_SERIAL_CONTROL
, SUM(A.TRANSACTION_QUANTITY) TOTAL_QOH
FROM MTL_ONHAND_QUANTITIES A
, MTL_SYSTEM_ITEMS_KFV B
, MTL_PARAMETERS C
, MTL_SECONDARY_INVENTORIES D
, HR_ORGANIZATION_UNITS E
WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND A.SUBINVENTORY_CODE = D.SECONDARY_INVENTORY_NAME
AND A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND A.ORGANIZATION_ID = C.ORGANIZATION_ID
AND A.ORGANIZATION_ID = D.ORGANIZATION_ID
AND A.ORGANIZATION_ID = E.ORGANIZATION_ID GROUP BY A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, A.SUBINVENTORY_CODE
, B.CONCATENATED_SEGMENTS
, B.DESCRIPTION
, B.PRIMARY_UOM_CODE
, C.ORGANIZATION_CODE
, E.NAME
, D.AVAILABILITY_TYPE
, D.RESERVABLE_TYPE
, D.INVENTORY_ATP_CODE
, D.LOCATOR_TYPE
, B.REVISION_QTY_CONTROL_CODE
, B.LOCATION_CONTROL_CODE
, B.LOT_CONTROL_CODE
, B.SERIAL_NUMBER_CONTROL_CODE