Product: | ICX - Oracle iProcurement |
---|---|
Description: | Obsolete |
Implementation/DBA Data: | APPS.ICX_MTL_SUPPLY_DEMAND_V |
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'