VIEW: APPS.MRP_SO_UPDATES_SUMMARY_V

Source

View Text - Preformatted

SELECT OOL.INVENTORY_ITEM_ID, DECODE(OOL.ITEM_TYPE_CODE, 'MODEL', OOL.INVENTORY_ITEM_ID, NULL) , OOL.LINE_ID, OOL.SHIP_FROM_ORG_ID, decode(nvl(OOL.MFG_LEAD_TIME,0), 0,OOL.SCHEDULE_SHIP_DATE, decode(OOL.LINE_ID, OOL.ATO_LINE_ID, OOL.SCHEDULE_SHIP_DATE, MRP_CALENDAR.DATE_OFFSET ( OOL.SHIP_FROM_ORG_ID, 1, OOL.SCHEDULE_SHIP_DATE, -1*(OOL.MFG_LEAD_TIME)))), 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)), 'Y' , OOL.SOLD_TO_ORG_ID, OOL.SHIP_TO_ORG_ID, OOL.INVOICE_TO_ORG_ID , OOL.DEMAND_CLASS_CODE, TO_CHAR(OOL.LINE_NUMBER), TO_NUMBER(NULL), inv_salesorder.get_salesorder_for_oeheader(OOL.HEADER_ID), OOL.LINE_ID, TO_CHAR(NULL) , 5 FROM OE_ORDER_LINES_ALL OOL WHERE OOL.VISIBLE_DEMAND_FLAG = 'Y' AND (OOL.SOURCE_DOCUMENT_TYPE_ID= 10 or OOL.LINE_CATEGORY_CODE = 'ORDER') and OOL.SOLD_TO_ORG_ID IS NOT NULL AND OOL.SHIP_TO_ORG_ID IS NOT NULL AND OOL.INVOICE_TO_ORG_ID IS NOT NULL AND OOL.OPEN_FLAG = 'Y' AND NVL(OOL.SHIPPED_QUANTITY, 0) = 0

View Text - HTML Formatted

SELECT OOL.INVENTORY_ITEM_ID
, DECODE(OOL.ITEM_TYPE_CODE
, 'MODEL'
, OOL.INVENTORY_ITEM_ID
, NULL)
, OOL.LINE_ID
, OOL.SHIP_FROM_ORG_ID
, DECODE(NVL(OOL.MFG_LEAD_TIME
, 0)
, 0
, OOL.SCHEDULE_SHIP_DATE
, DECODE(OOL.LINE_ID
, OOL.ATO_LINE_ID
, OOL.SCHEDULE_SHIP_DATE
, MRP_CALENDAR.DATE_OFFSET ( OOL.SHIP_FROM_ORG_ID
, 1
, OOL.SCHEDULE_SHIP_DATE
, -1*(OOL.MFG_LEAD_TIME))))
, 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))
, 'Y'
, OOL.SOLD_TO_ORG_ID
, OOL.SHIP_TO_ORG_ID
, OOL.INVOICE_TO_ORG_ID
, OOL.DEMAND_CLASS_CODE
, TO_CHAR(OOL.LINE_NUMBER)
, TO_NUMBER(NULL)
, INV_SALESORDER.GET_SALESORDER_FOR_OEHEADER(OOL.HEADER_ID)
, OOL.LINE_ID
, TO_CHAR(NULL)
, 5
FROM OE_ORDER_LINES_ALL OOL
WHERE OOL.VISIBLE_DEMAND_FLAG = 'Y'
AND (OOL.SOURCE_DOCUMENT_TYPE_ID= 10 OR OOL.LINE_CATEGORY_CODE = 'ORDER')
AND OOL.SOLD_TO_ORG_ID IS NOT NULL
AND OOL.SHIP_TO_ORG_ID IS NOT NULL
AND OOL.INVOICE_TO_ORG_ID IS NOT NULL
AND OOL.OPEN_FLAG = 'Y'
AND NVL(OOL.SHIPPED_QUANTITY
, 0) = 0