VIEW: MSC.MSC_SUP_DEM_HISTORY#

Source

View Text - Preformatted

select HISTORY_ID HISTORY_ID, PLAN_ID PLAN_ID, TRANSACTION_ID TRANSACTION_ID, PUBLISHER_NAME PUBLISHER_NAME, PUBLISHER_SITE_NAME PUBLISHER_SITE_NAME, PUBLISHER_ORDER_TYPE PUBLISHER_ORDER_TYPE, PUBLISHER_ORDER_TYPE_DESC PUBLISHER_ORDER_TYPE_DESC, PUBLISHER_ITEM_NAME PUBLISHER_ITEM_NAME, PUB_ITEM_DESCRIPTION PUB_ITEM_DESCRIPTION, TRADING_PARTNER_ITEM_NAME TRADING_PARTNER_ITEM_NAME, TP_ITEM_DESCRIPTION TP_ITEM_DESCRIPTION, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME, ORDER_NUMBER ORDER_NUMBER, LINE_NUMBER LINE_NUMBER, RELEASE_NUMBER RELEASE_NUMBER, END_ORDER_NUMBER END_ORDER_NUMBER, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER, END_ORDER_REL_NUMBER END_ORDER_REL_NUMBER, DESIGNATOR_OLD DESIGNATOR_OLD, DESIGNATOR_NEW DESIGNATOR_NEW, VERSION_OLD VERSION_OLD, VERSION_NEW VERSION_NEW, QUANTITY_OLD QUANTITY_OLD, QUANTITY_NEW QUANTITY_NEW, COMMENTS_OLD COMMENTS_OLD, COMMENTS_NEW COMMENTS_NEW, KEY_DATE_OLD KEY_DATE_OLD, KEY_DATE_NEW KEY_DATE_NEW, SHIP_DATE_OLD SHIP_DATE_OLD, SHIP_DATE_NEW SHIP_DATE_NEW, RECEIPT_DATE_OLD RECEIPT_DATE_OLD, RECEIPT_DATE_NEW RECEIPT_DATE_NEW, NEW_SCHEDULE_DATE_OLD NEW_SCHEDULE_DATE_OLD, NEW_SCHEDULE_DATE_NEW NEW_SCHEDULE_DATE_NEW, NEW_ORDER_PLACEMENT_DATE_OLD NEW_ORDER_PLACEMENT_DATE_OLD, NEW_ORDER_PLACEMENT_DATE_NEW NEW_ORDER_PLACEMENT_DATE_NEW, ORIGINAL_PROMISED_DATE_OLD ORIGINAL_PROMISED_DATE_OLD, ORIGINAL_PROMISED_DATE_NEW ORIGINAL_PROMISED_DATE_NEW, REQUEST_DATE_OLD REQUEST_DATE_OLD, REQUEST_DATE_NEW REQUEST_DATE_NEW, PLANNED_WIP_START_DATE_OLD PLANNED_WIP_START_DATE_OLD, PLANNED_WIP_START_DATE_NEW PLANNED_WIP_START_DATE_NEW, PLANNED_WIP_END_DATE_OLD PLANNED_WIP_END_DATE_OLD, PLANNED_WIP_END_DATE_NEW PLANNED_WIP_END_DATE_NEW, WIP_START_DATE_OLD WIP_START_DATE_OLD, WIP_START_DATE_NEW WIP_START_DATE_NEW, WIP_END_DATE_OLD WIP_END_DATE_OLD, WIP_END_DATE_NEW WIP_END_DATE_NEW, LAST_REFRESH_NUMBER_OLD LAST_REFRESH_NUMBER_OLD, LAST_REFRESH_NUMBER_NEW LAST_REFRESH_NUMBER_NEW, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, DMLTYPE DMLTYPE, ITEM_NAME ITEM_NAME, OWNER_ITEM_NAME OWNER_ITEM_NAME, CUSTOMER_ITEM_NAME CUSTOMER_ITEM_NAME, SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME, ITEM_DESCRIPTION ITEM_DESCRIPTION, OWNER_ITEM_DESCRIPTION OWNER_ITEM_DESCRIPTION, SUPPLIER_ITEM_DESCRIPTION SUPPLIER_ITEM_DESCRIPTION, CUSTOMER_ITEM_DESCRIPTION CUSTOMER_ITEM_DESCRIPTION, BUCKET_TYPE_NEW BUCKET_TYPE_NEW, BUCKET_TYPE_OLD BUCKET_TYPE_OLD, USE_FOR_COMPARISON USE_FOR_COMPARISON from "MSC"."MSC_SUP_DEM_HISTORY"

View Text - HTML Formatted

SELECT HISTORY_ID HISTORY_ID
, PLAN_ID PLAN_ID
, TRANSACTION_ID TRANSACTION_ID
, PUBLISHER_NAME PUBLISHER_NAME
, PUBLISHER_SITE_NAME PUBLISHER_SITE_NAME
, PUBLISHER_ORDER_TYPE PUBLISHER_ORDER_TYPE
, PUBLISHER_ORDER_TYPE_DESC PUBLISHER_ORDER_TYPE_DESC
, PUBLISHER_ITEM_NAME PUBLISHER_ITEM_NAME
, PUB_ITEM_DESCRIPTION PUB_ITEM_DESCRIPTION
, TRADING_PARTNER_ITEM_NAME TRADING_PARTNER_ITEM_NAME
, TP_ITEM_DESCRIPTION TP_ITEM_DESCRIPTION
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME
, ORDER_NUMBER ORDER_NUMBER
, LINE_NUMBER LINE_NUMBER
, RELEASE_NUMBER RELEASE_NUMBER
, END_ORDER_NUMBER END_ORDER_NUMBER
, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER
, END_ORDER_REL_NUMBER END_ORDER_REL_NUMBER
, DESIGNATOR_OLD DESIGNATOR_OLD
, DESIGNATOR_NEW DESIGNATOR_NEW
, VERSION_OLD VERSION_OLD
, VERSION_NEW VERSION_NEW
, QUANTITY_OLD QUANTITY_OLD
, QUANTITY_NEW QUANTITY_NEW
, COMMENTS_OLD COMMENTS_OLD
, COMMENTS_NEW COMMENTS_NEW
, KEY_DATE_OLD KEY_DATE_OLD
, KEY_DATE_NEW KEY_DATE_NEW
, SHIP_DATE_OLD SHIP_DATE_OLD
, SHIP_DATE_NEW SHIP_DATE_NEW
, RECEIPT_DATE_OLD RECEIPT_DATE_OLD
, RECEIPT_DATE_NEW RECEIPT_DATE_NEW
, NEW_SCHEDULE_DATE_OLD NEW_SCHEDULE_DATE_OLD
, NEW_SCHEDULE_DATE_NEW NEW_SCHEDULE_DATE_NEW
, NEW_ORDER_PLACEMENT_DATE_OLD NEW_ORDER_PLACEMENT_DATE_OLD
, NEW_ORDER_PLACEMENT_DATE_NEW NEW_ORDER_PLACEMENT_DATE_NEW
, ORIGINAL_PROMISED_DATE_OLD ORIGINAL_PROMISED_DATE_OLD
, ORIGINAL_PROMISED_DATE_NEW ORIGINAL_PROMISED_DATE_NEW
, REQUEST_DATE_OLD REQUEST_DATE_OLD
, REQUEST_DATE_NEW REQUEST_DATE_NEW
, PLANNED_WIP_START_DATE_OLD PLANNED_WIP_START_DATE_OLD
, PLANNED_WIP_START_DATE_NEW PLANNED_WIP_START_DATE_NEW
, PLANNED_WIP_END_DATE_OLD PLANNED_WIP_END_DATE_OLD
, PLANNED_WIP_END_DATE_NEW PLANNED_WIP_END_DATE_NEW
, WIP_START_DATE_OLD WIP_START_DATE_OLD
, WIP_START_DATE_NEW WIP_START_DATE_NEW
, WIP_END_DATE_OLD WIP_END_DATE_OLD
, WIP_END_DATE_NEW WIP_END_DATE_NEW
, LAST_REFRESH_NUMBER_OLD LAST_REFRESH_NUMBER_OLD
, LAST_REFRESH_NUMBER_NEW LAST_REFRESH_NUMBER_NEW
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, DMLTYPE DMLTYPE
, ITEM_NAME ITEM_NAME
, OWNER_ITEM_NAME OWNER_ITEM_NAME
, CUSTOMER_ITEM_NAME CUSTOMER_ITEM_NAME
, SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, OWNER_ITEM_DESCRIPTION OWNER_ITEM_DESCRIPTION
, SUPPLIER_ITEM_DESCRIPTION SUPPLIER_ITEM_DESCRIPTION
, CUSTOMER_ITEM_DESCRIPTION CUSTOMER_ITEM_DESCRIPTION
, BUCKET_TYPE_NEW BUCKET_TYPE_NEW
, BUCKET_TYPE_OLD BUCKET_TYPE_OLD
, USE_FOR_COMPARISON USE_FOR_COMPARISON
FROM "MSC"."MSC_SUP_DEM_HISTORY"