VIEW: APPS.ICX_MTL_SUPPLY_DEMAND_V

Source

View Text - Preformatted

SELECT SUPDEM.ORGANIZATION_ID , SUPDEM.INVENTORY_ITEM_ID , SUPDEM.REQUIREMENT_DATE REQ_DATE , DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE ,1, ICX_GET_ORDER.GET_PO_NUMBER(DISPOSITION_ID) ) PURCH_ORD , DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE,1,DISPOSITION_ID) , DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE ,18, ICX_GET_ORDER.GET_REQ_NUMBER(DISPOSITION_ID) ) REQUISITIONS , DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE,18,DISPOSITION_ID) , DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE ,2, ICX_GET_ORDER.GET_SO_NUMBER(DISPOSITION_ID) ,9, ICX_GET_ORDER.GET_SO_NUMBER(DISPOSITION_ID) ) SALES_ORD , DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE ,2,DISPOSITION_ID ,9, DISPOSITION_ID) , DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE ,3,DISPOSITION_ID ,10, DISPOSITION_ID ) ACCOUNT_NO , DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE ,4, ICX_GET_ORDER.GET_WIP_NUMBER(DISPOSITION_ID) ,5, ICX_GET_ORDER.GET_WIP_NUMBER(DISPOSITION_ID) ,7, ICX_GET_ORDER.GET_WIP_NUMBER(DISPOSITION_ID) ,13, ICX_GET_ORDER.GET_WIP_NUMBER(DISPOSITION_ID) ,14, ICX_GET_ORDER.GET_WIP_NUMBER(DISPOSITION_ID) ,23, ICX_GET_ORDER.GET_WIP_NUMBER(DISPOSITION_ID) ) W_I_P , DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE ,4,DISPOSITION_ID ,5, DISPOSITION_ID ,7,DISPOSITION_ID ,13,DISPOSITION_ID ,14, DISPOSITION_ID ,23,DISPOSITION_ID) , DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE ,6,DISPOSITION_ID ,8, DISPOSITION_ID ,11,DISPOSITION_ID ,12,DISPOSITION_ID ,15, DISPOSITION_ID ,16,DISPOSITION_ID ,17,DISPOSITION_ID ,19, DISPOSITION_ID ,20,DISPOSITION_ID ,21,DISPOSITION_ID ,22, DISPOSITION_ID ) OTHER , DECODE(SUPDEM.SUPPLY_DEMAND_TYPE,1,SUPDEM.QUANTITY) RESRVNS , DECODE(SUPDEM.SUPPLY_DEMAND_TYPE,2,SUPDEM.QUANTITY) RECEIPTS , SUPDEM.ON_HAND_QUANTITY AVAILABLE FROM MTL_SUPPLY_DEMAND_TEMP SUPDEM WHERE SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE IS NOT NULL AND SUPDEM.RECORD_TYPE = 'SD'

View Text - HTML Formatted

SELECT SUPDEM.ORGANIZATION_ID
, SUPDEM.INVENTORY_ITEM_ID
, SUPDEM.REQUIREMENT_DATE REQ_DATE
, DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE
, 1
, ICX_GET_ORDER.GET_PO_NUMBER(DISPOSITION_ID) ) PURCH_ORD
, DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE
, 1
, DISPOSITION_ID)
, DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE
, 18
, ICX_GET_ORDER.GET_REQ_NUMBER(DISPOSITION_ID) ) REQUISITIONS
, DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE
, 18
, DISPOSITION_ID)
, DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE
, 2
, ICX_GET_ORDER.GET_SO_NUMBER(DISPOSITION_ID)
, 9
, ICX_GET_ORDER.GET_SO_NUMBER(DISPOSITION_ID) ) SALES_ORD
, DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE
, 2
, DISPOSITION_ID
, 9
, DISPOSITION_ID)
, DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE
, 3
, DISPOSITION_ID
, 10
, DISPOSITION_ID ) ACCOUNT_NO
, DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE
, 4
, ICX_GET_ORDER.GET_WIP_NUMBER(DISPOSITION_ID)
, 5
, ICX_GET_ORDER.GET_WIP_NUMBER(DISPOSITION_ID)
, 7
, ICX_GET_ORDER.GET_WIP_NUMBER(DISPOSITION_ID)
, 13
, ICX_GET_ORDER.GET_WIP_NUMBER(DISPOSITION_ID)
, 14
, ICX_GET_ORDER.GET_WIP_NUMBER(DISPOSITION_ID)
, 23
, ICX_GET_ORDER.GET_WIP_NUMBER(DISPOSITION_ID) ) W_I_P
, DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE
, 4
, DISPOSITION_ID
, 5
, DISPOSITION_ID
, 7
, DISPOSITION_ID
, 13
, DISPOSITION_ID
, 14
, DISPOSITION_ID
, 23
, DISPOSITION_ID)
, DECODE(SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE
, 6
, DISPOSITION_ID
, 8
, DISPOSITION_ID
, 11
, DISPOSITION_ID
, 12
, DISPOSITION_ID
, 15
, DISPOSITION_ID
, 16
, DISPOSITION_ID
, 17
, DISPOSITION_ID
, 19
, DISPOSITION_ID
, 20
, DISPOSITION_ID
, 21
, DISPOSITION_ID
, 22
, DISPOSITION_ID ) OTHER
, DECODE(SUPDEM.SUPPLY_DEMAND_TYPE
, 1
, SUPDEM.QUANTITY) RESRVNS
, DECODE(SUPDEM.SUPPLY_DEMAND_TYPE
, 2
, SUPDEM.QUANTITY) RECEIPTS
, SUPDEM.ON_HAND_QUANTITY AVAILABLE
FROM MTL_SUPPLY_DEMAND_TEMP SUPDEM
WHERE SUPDEM.SUPPLY_DEMAND_SOURCE_TYPE IS NOT NULL
AND SUPDEM.RECORD_TYPE = 'SD'