[Home] [Help] [Dependency Information]

VIEW: MSC.MSC_SUP_DEM_HISTORY#

Object Details

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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

Dependencies

[top of page]

MSC

MSC_SUP_DEM_HISTORY

APPS

MSC_SUP_DEM_HISTORY