VIEW: APPS.PJM_PROJECT_OM_DEMAND_V

Source

View Text - Preformatted

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 */ , PJM_UTILS.GET_DEMAND_QUANTITY (OOL.LINE_ID) /* 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'

View Text - HTML Formatted

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 */
, PJM_UTILS.GET_DEMAND_QUANTITY (OOL.LINE_ID) /* 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'