View: PJM_PROJECT_OM_DEMAND_V

Product:	PJM - Project Manufacturing
Description:	Sales order demand view with project and task references
Implementation/DBA Data:	APPS.PJM_PROJECT_OM_DEMAND_V

View Text

SELECT OOL.INVENTORY_ITEM_ID /* INVENTORY_ITEM_ID */
, OOL.SHIP_FROM_ORG_ID /* ORGANIZATION_ID */
, TO_CHAR(NULL) /* REVISION */
, INV_SALESORDER.GET_SALESORDER_FOR_OEHEADER(OOL.HEADER_ID) /* DEMAND_SOURCE_HEADER_ID */
, TO_CHAR(OOL.LINE_ID) /* DEMAND_SOURCE_LINE */
, 2 /* DEMAND_SOURCE_TYPE */
, TO_CHAR(NULL) /* DEMAND_SOURCE_DELIVERY */
, OOL.LINE_ID /* DEMAND_ID */
, TO_NUMBER(NULL) /* PARENT_DEMAND_ID */
, OOL.DEMAND_CLASS_CODE /* DEMAND_CLASS */
, TO_CHAR(NULL) /* SUBINVENTORY */
, MRP_OE.MRP_DATE(OOL.LINE_ID) /* MRP_DATE */
, OOL.SCHEDULE_SHIP_DATE /* REQUIRMENT_DATE */
, MRP_OE.MRP_QUANTITY(OOL.LINE_ID) /* MRP_QUANTITY */
, 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 */
, INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY ( OOL.SHIP_FROM_ORG_ID
, OOL.INVENTORY_ITEM_ID
, OOL.ORDER_QUANTITY_UOM
, OOL.SHIPPED_QUANTITY) /* COMPLETED_QUANTITY */
, NVL(MD.PRIMARY_UOM_QUANTITY
, 0) /* RESERVATION_QUANTITY */
, MRP_OE.AVAILABLE_TO_MRP(OOL.LINE_ID) /* AVAILABLE_TO_MRP */
, 1 /* RESERVATION_TYPE */
, OOL.LINE_NUMBER /* USER_LINE_NUM */
, TO_NUMBER(NULL) /* CUSTOMER_ID */
, TO_NUMBER(NULL) /* BILL_TO_SITE_USE_ID */
, TO_NUMBER(NULL) /* SHIP_TO_SITE_USE_ID */
, TO_CHAR(NULL) /* RTO_MODEL_SOURCE_LINE */
, MRP_OE.UPDATED_FLAG(OOL.LINE_ID) /* UPDATED_FLAG */
, OOL.PROJECT_ID /* PROJECT_ID */
, OOL.TASK_ID /* TASK_ID */
, OOL.END_ITEM_UNIT_NUMBER /* END_ITEM_UNIT_NUMBER */
FROM OE_ORDER_LINES_ALL OOL
, MTL_DEMAND MD
WHERE OOL.VISIBLE_DEMAND_FLAG = 'Y'
AND OOL.LINE_ID = MD.DEMAND_SOURCE_LINE (+)
AND NVL(MD.DEMAND_SOURCE_TYPE
, 2) IN (2
, 8
, 12)
AND NVL(MD.RESERVATION_TYPE
, 2) IN (2
, 3)

Columns