VIEW: APPS.POS_MTL_ONHAND_LOCATOR_KFV

Source

View Text - Preformatted

SELECT A.ORGANIZATION_ID, A.INVENTORY_ITEM_ID, B.CONCATENATED_SEGMENTS ITEM, A.REVISION, SUM(A.TRANSACTION_QUANTITY) TOTAL_QOH, A.SUBINVENTORY_CODE, NVL(A.LOCATOR_ID, -1) LOCATOR_ID, F.CONCATENATED_SEGMENTS LOCATION, B.DESCRIPTION ITEM_DESCRIPTION, B.PRIMARY_UOM_CODE, C.ORGANIZATION_CODE, E.NAME ORGANIZATION_NAME, DECODE(D.AVAILABILITY_TYPE, 1, '*', NULL) NET, DECODE(D.RESERVABLE_TYPE, 1, '*', NULL) RSV, DECODE(D.INVENTORY_ATP_CODE, 1, '*', NULL) ATP, D.LOCATOR_TYPE, B.ATTRIBUTE14 ITEM_URL FROM MTL_ONHAND_QUANTITIES A, MTL_SYSTEM_ITEMS_KFV B, MTL_PARAMETERS C, MTL_SECONDARY_INVENTORIES D, MTL_ITEM_LOCATIONS_KFV F, 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 AND A.LOCATOR_ID IS NOT NULL AND A.LOCATOR_ID = F.INVENTORY_LOCATION_ID AND A.ORGANIZATION_ID = F.ORGANIZATION_ID GROUP BY A.ORGANIZATION_ID, A.INVENTORY_ITEM_ID, B.CONCATENATED_SEGMENTS, A.REVISION, A.SUBINVENTORY_CODE, A.LOCATOR_ID, F.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.ATTRIBUTE14 UNION SELECT A.ORGANIZATION_ID, A.INVENTORY_ITEM_ID, B.CONCATENATED_SEGMENTS ITEM, A.REVISION, SUM(A.TRANSACTION_QUANTITY) TOTAL_QOH, A.SUBINVENTORY_CODE, NVL(LOCATOR_ID, -1) LOCATOR_ID, NULL LOCATION, B.DESCRIPTION ITEM_DESCRIPTION, B.PRIMARY_UOM_CODE, C.ORGANIZATION_CODE, E.NAME ORGANIZATION_NAME, DECODE(D.AVAILABILITY_TYPE, 1, '*', NULL) NET, DECODE(D.RESERVABLE_TYPE, 1, '*', NULL) RSV, DECODE(D.INVENTORY_ATP_CODE, 1, '*', NULL) ATP, D.LOCATOR_TYPE, B.ATTRIBUTE14 ITEM_URL 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 AND A.LOCATOR_ID IS NULL GROUP BY A.ORGANIZATION_ID, A.INVENTORY_ITEM_ID, B.CONCATENATED_SEGMENTS, A.REVISION, A.SUBINVENTORY_CODE, LOCATOR_ID, 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.ATTRIBUTE14

View Text - HTML Formatted

SELECT A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, B.CONCATENATED_SEGMENTS ITEM
, A.REVISION
, SUM(A.TRANSACTION_QUANTITY) TOTAL_QOH
, A.SUBINVENTORY_CODE
, NVL(A.LOCATOR_ID
, -1) LOCATOR_ID
, F.CONCATENATED_SEGMENTS LOCATION
, B.DESCRIPTION ITEM_DESCRIPTION
, B.PRIMARY_UOM_CODE
, C.ORGANIZATION_CODE
, E.NAME ORGANIZATION_NAME
, DECODE(D.AVAILABILITY_TYPE
, 1
, '*'
, NULL) NET
, DECODE(D.RESERVABLE_TYPE
, 1
, '*'
, NULL) RSV
, DECODE(D.INVENTORY_ATP_CODE
, 1
, '*'
, NULL) ATP
, D.LOCATOR_TYPE
, B.ATTRIBUTE14 ITEM_URL
FROM MTL_ONHAND_QUANTITIES A
, MTL_SYSTEM_ITEMS_KFV B
, MTL_PARAMETERS C
, MTL_SECONDARY_INVENTORIES D
, MTL_ITEM_LOCATIONS_KFV F
, 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
AND A.LOCATOR_ID IS NOT NULL
AND A.LOCATOR_ID = F.INVENTORY_LOCATION_ID
AND A.ORGANIZATION_ID = F.ORGANIZATION_ID GROUP BY A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, B.CONCATENATED_SEGMENTS
, A.REVISION
, A.SUBINVENTORY_CODE
, A.LOCATOR_ID
, F.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.ATTRIBUTE14 UNION SELECT A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, B.CONCATENATED_SEGMENTS ITEM
, A.REVISION
, SUM(A.TRANSACTION_QUANTITY) TOTAL_QOH
, A.SUBINVENTORY_CODE
, NVL(LOCATOR_ID
, -1) LOCATOR_ID
, NULL LOCATION
, B.DESCRIPTION ITEM_DESCRIPTION
, B.PRIMARY_UOM_CODE
, C.ORGANIZATION_CODE
, E.NAME ORGANIZATION_NAME
, DECODE(D.AVAILABILITY_TYPE
, 1
, '*'
, NULL) NET
, DECODE(D.RESERVABLE_TYPE
, 1
, '*'
, NULL) RSV
, DECODE(D.INVENTORY_ATP_CODE
, 1
, '*'
, NULL) ATP
, D.LOCATOR_TYPE
, B.ATTRIBUTE14 ITEM_URL
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
AND A.LOCATOR_ID IS NULL GROUP BY A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, B.CONCATENATED_SEGMENTS
, A.REVISION
, A.SUBINVENTORY_CODE
, LOCATOR_ID
, 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.ATTRIBUTE14