View: MTL_DEMAND_OM_VIEW

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_DEMAND_OM_VIEW

View Text

SELECT OOL.LINE_ID DEMAND_ID
, OOL.SHIP_FROM_ORG_ID ORGANIZATION_ID
, OOL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, DECODE(OOL.SOURCE_DOCUMENT_TYPE_ID
, 10
, 8
, DECODE(OOL.LINE_CATEGORY_CODE
, 'ORDER'
, 2
, 12)) DEMAND_SOURCE_TYPE
, INV_SALESORDER.GET_SALESORDER_FOR_OEHEADER(OOL.HEADER_ID) DEMAND_SOURCE_HEADER_ID
, TO_CHAR(OOL.LINE_ID) DEMAND_SOURCE_LINE
, TO_CHAR(NULL) DEMAND_SOURCE_DELIVERY
, TO_CHAR(NULL) DEMAND_SOURCE_NAME
, OOL.ORDER_QUANTITY_UOM UOM_CODE
, OOL.ORDERED_QUANTITY LINE_ITEM_QUANTITY
, DECODE(OOL.ORDERED_QUANTITY
, NULL
, 0
, INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(OOL.SHIP_FROM_ORG_ID
, OOL.INVENTORY_ITEM_ID
, OOL.ORDER_QUANTITY_UOM
, OOL.ORDERED_QUANTITY)) PRIMARY_UOM_QUANTITY
, TO_NUMBER(NULL) LINE_ITEM_RESERVATION_QTY
, NVL(MD1.PRIMARY_UOM_QUANTITY
, 0) RESERVATION_QUANTITY
, DECODE(OOL.SHIPPED_QUANTITY
, NULL
, 0
, INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(OOL.SHIP_FROM_ORG_ID
, OOL.INVENTORY_ITEM_ID
, OOL.ORDER_QUANTITY_UOM
, OOL.SHIPPED_QUANTITY)) COMPLETED_QUANTITY
, OOL.SCHEDULE_SHIP_DATE REQUIREMENT_DATE
, 1 RESERVATION_TYPE
, TO_NUMBER(NULL) PARENT_DEMAND_ID
, TO_CHAR(NULL) EXTERNAL_SOURCE_CODE
, TO_NUMBER(NULL) EXTERNAL_SOURCE_LINE_ID
, TO_NUMBER(NULL) SUPPLY_SOURCE_TYPE
, TO_NUMBER(NULL) SUPPLY_SOURCE_HEADER_ID
, MRP_OE.UPDATED_FLAG(OOL.LINE_ID) UPDATED_FLAG
, TO_CHAR(NULL) REVISION
, TO_CHAR(NULL) LOT_NUMBER
, TO_CHAR(NULL) SERIAL_NUMBER
, TO_CHAR(NULL) SUBINVENTORY
, TO_NUMBER(NULL) LOCATOR_ID
, MRP_OE.AVAILABLE_TO_MRP(OOL.LINE_ID) AVAILABLE_TO_MRP
, MRP_OE.AVAILABLE_TO_ATP(OOL.LINE_ID) AVAILABLE_TO_ATP
, OOL.DEMAND_CLASS_CODE DEMAND_CLASS
, DECODE( SIGN(NVL(OOL.SHIPPED_QUANTITY
, 0))
, 1
, 2
, 0
, 1
, 2) ROW_STATUS_FLAG
, MRP_OE.MRP_DATE(OOL.LINE_ID) MRP_DATE
, MRP_OE.MRP_QUANTITY(OOL.LINE_ID) MRP_QUANTITY
, OOL.SOLD_TO_ORG_ID CUSTOMER_ID
, OOL.INVOICE_TO_ORG_ID BILL_TO_SITE_USE_ID
, OOL.SHIP_TO_ORG_ID SHIP_TO_SITE_USE_ID
, DECODE(OOL.ITEM_TYPE_CODE
, 'CLASS'
, 2
, 'CONFIG'
, 4
, 'MODEL'
, 1
, 'OPTION'
, 3
, 'STANDARD'
, 6
, -1) DEMAND_TYPE
, TO_CHAR(OOL.LINE_NUMBER) USER_LINE_NUM
, TO_CHAR(OOL.SHIPMENT_NUMBER) USER_DELIVERY
, OOL.ATO_LINE_ID ATO_LINE_ID
, OOL.MFG_LEAD_TIME MFG_LEAD_TIME
, OOL.OPEN_FLAG OPEN_FLAG
FROM OE_ORDER_LINES_ALL OOL
, MTL_DEMAND MD1
WHERE OE_INSTALL.GET_ACTIVE_PRODUCT = 'ONT'
AND TO_CHAR(OOL.LINE_ID) = MD1.DEMAND_SOURCE_LINE(+)
AND NVL(MD1.DEMAND_SOURCE_TYPE
, 2) IN (2
, 8
, 12)
AND NVL(MD1.RESERVATION_TYPE
, 2) IN (2
, 3)

Columns