eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MRP_DEMAND_OM_RESERVATIONS_V

Source

View Text - Preformatted


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(MRP_OE.TOTAL_RESERV_QTY(OOL.LINE_ID), 0) TOTAL_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, OOL.SUBINVENTORY SUBINVENTORY, TO_NUMBER(NULL) LOCATOR_ID, VISIBLE_DEMAND_FLAG, 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

View Text - HTML Formatted

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(MRP_OE.TOTAL_RESERV_QTY(OOL.LINE_ID)
, 0) TOTAL_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
, OOL.SUBINVENTORY SUBINVENTORY
, TO_NUMBER(NULL) LOCATOR_ID
, VISIBLE_DEMAND_FLAG
, 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