Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_SUP_DEM_HISTORY_V |
SELECT HISTORY_ID
, DECODE(1
, 1
, PUBLISHER_NAME || '('||PUBLISHER_SITE_NAME||')') AS FROMCOMPORG
, DECODE(1
, 1
, PUBLISHER_NAME || '('||PUBLISHER_SITE_NAME||')') AS TOCOMPORG
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME
, CUSTOMER_ITEM_NAME CUSTOMER_ITEM_NAME
, CUSTOMER_ITEM_DESCRIPTION CUSTOMER_ITEM_DESC
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME
, SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME
, SUPPLIER_ITEM_DESCRIPTION SUPPLIER_ITEM_DESC
, ITEM_NAME ITEM_NAME
, ITEM_DESCRIPTION ITEM_DESC
, OWNER_ITEM_NAME OWNER_ITEM_NAME
, OWNER_ITEM_DESCRIPTION OWNER_ITEM_DESC
, PUBLISHER_ORDER_TYPE
, PUBLISHER_ORDER_TYPE_DESC
, DESIGNATOR_NEW AS DESIGNATOR
, VERSION_NEW AS VERSION
, LAST_UPDATE_DATE
, QUANTITY_NEW
, KEY_DATE_NEW
, SHIP_DATE_NEW
, RECEIPT_DATE_NEW
, NEW_SCHEDULE_DATE_NEW
FROM MSC_SUP_DEM_HISTORY
WHERE PLAN_ID=-1
AND PUBLISHER_ORDER_TYPE IN (1
, 2
, 3)
AND KEY_DATE_NEW IS NOT NULL