VIEW: APPS.INVBV_INVENTORY_RESERVATIONS

Source

View Text - Preformatted

SELECT M.DEMAND_ID, M.ORGANIZATION_ID, M.INVENTORY_ITEM_ID, M.REQUIREMENT_DATE, M.DEMAND_SOURCE_TYPE, M.DEMAND_SOURCE_HEADER_ID, DECODE (M.DEMAND_SOURCE_TYPE, 2, M.DEMAND_SOURCE_HEADER_ID, 8, M.DEMAND_SOURCE_HEADER_ID, 12, M.DEMAND_SOURCE_HEADER_ID, NULL) SALES_ORDER_ID, DECODE (M.DEMAND_SOURCE_TYPE, 3, M.DEMAND_SOURCE_HEADER_ID, NULL) ACCOUNT_ID, DECODE (M.DEMAND_SOURCE_TYPE, 6, M.DEMAND_SOURCE_HEADER_ID, NULL) ACCOUNT_ALIAS_ID, DECODE (M.DEMAND_SOURCE_TYPE, 2, NULL, 3, NULL, 6, NULL, 8, NULL, 12, NULL, M.DEMAND_SOURCE_NAME), M.UOM_CODE UOM, M.LINE_ITEM_QUANTITY RESERVED_QUANTITY, (M.COMPLETED_QUANTITY * (inv_convert.inv_um_convert(M.INVENTORY_ITEM_ID, 5, 1, MSI.PRIMARY_UOM_CODE, M.UOM_CODE, null, null))) ISSUED_QUANTITY, (M.LINE_ITEM_QUANTITY - (M.COMPLETED_QUANTITY * (inv_convert.inv_um_convert(M.INVENTORY_ITEM_ID, 5, 1, MSI.PRIMARY_UOM_CODE, M.UOM_CODE, null, null)))) PENDING_ISSUE_QUANTITY, M.REVISION , M.LOT_NUMBER, M.SUBINVENTORY, M.LOCATOR_ID, M.USER_LINE_NUM, M.CREATED_BY, M.CREATION_DATE, M.LAST_UPDATED_BY, M.LAST_UPDATE_DATE FROM MTL_SYSTEM_ITEMS MSI, MTL_DEMAND M WHERE MSI.ORGANIZATION_ID = M.ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = M.INVENTORY_ITEM_ID AND M.RESERVATION_TYPE = 2 AND (M.PRIMARY_UOM_QUANTITY-M.COMPLETED_QUANTITY) > 0 AND (M.DEMAND_SOURCE_TYPE IN (2,8,12, 3, 6, 13) OR M.DEMAND_SOURCE_TYPE > 99) AND '_SEC:M.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT M.DEMAND_ID
, M.ORGANIZATION_ID
, M.INVENTORY_ITEM_ID
, M.REQUIREMENT_DATE
, M.DEMAND_SOURCE_TYPE
, M.DEMAND_SOURCE_HEADER_ID
, DECODE (M.DEMAND_SOURCE_TYPE
, 2
, M.DEMAND_SOURCE_HEADER_ID
, 8
, M.DEMAND_SOURCE_HEADER_ID
, 12
, M.DEMAND_SOURCE_HEADER_ID
, NULL) SALES_ORDER_ID
, DECODE (M.DEMAND_SOURCE_TYPE
, 3
, M.DEMAND_SOURCE_HEADER_ID
, NULL) ACCOUNT_ID
, DECODE (M.DEMAND_SOURCE_TYPE
, 6
, M.DEMAND_SOURCE_HEADER_ID
, NULL) ACCOUNT_ALIAS_ID
, DECODE (M.DEMAND_SOURCE_TYPE
, 2
, NULL
, 3
, NULL
, 6
, NULL
, 8
, NULL
, 12
, NULL
, M.DEMAND_SOURCE_NAME)
, M.UOM_CODE UOM
, M.LINE_ITEM_QUANTITY RESERVED_QUANTITY
, (M.COMPLETED_QUANTITY * (INV_CONVERT.INV_UM_CONVERT(M.INVENTORY_ITEM_ID
, 5
, 1
, MSI.PRIMARY_UOM_CODE
, M.UOM_CODE
, NULL
, NULL))) ISSUED_QUANTITY
, (M.LINE_ITEM_QUANTITY - (M.COMPLETED_QUANTITY * (INV_CONVERT.INV_UM_CONVERT(M.INVENTORY_ITEM_ID
, 5
, 1
, MSI.PRIMARY_UOM_CODE
, M.UOM_CODE
, NULL
, NULL)))) PENDING_ISSUE_QUANTITY
, M.REVISION
, M.LOT_NUMBER
, M.SUBINVENTORY
, M.LOCATOR_ID
, M.USER_LINE_NUM
, M.CREATED_BY
, M.CREATION_DATE
, M.LAST_UPDATED_BY
, M.LAST_UPDATE_DATE
FROM MTL_SYSTEM_ITEMS MSI
, MTL_DEMAND M
WHERE MSI.ORGANIZATION_ID = M.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = M.INVENTORY_ITEM_ID
AND M.RESERVATION_TYPE = 2
AND (M.PRIMARY_UOM_QUANTITY-M.COMPLETED_QUANTITY) > 0
AND (M.DEMAND_SOURCE_TYPE IN (2
, 8
, 12
, 3
, 6
, 13) OR M.DEMAND_SOURCE_TYPE > 99)
AND '_SEC:M.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY