VIEW: APPS.MSC_SUP_DEM_HISTORY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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