[Home] [Help] [Dependency Information]
Object Name: | MSC_SUP_DEM_HISTORY# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HISTORY_ID | NUMBER | |||
PLAN_ID | NUMBER | |||
TRANSACTION_ID | NUMBER | |||
PUBLISHER_NAME | VARCHAR2 | (255) | ||
PUBLISHER_SITE_NAME | VARCHAR2 | (40) | ||
PUBLISHER_ORDER_TYPE | NUMBER | |||
PUBLISHER_ORDER_TYPE_DESC | VARCHAR2 | (80) | ||
PUBLISHER_ITEM_NAME | VARCHAR2 | (250) | ||
PUB_ITEM_DESCRIPTION | VARCHAR2 | (250) | ||
TRADING_PARTNER_ITEM_NAME | VARCHAR2 | (250) | ||
TP_ITEM_DESCRIPTION | VARCHAR2 | (250) | ||
CUSTOMER_NAME | VARCHAR2 | (255) | ||
CUSTOMER_SITE_NAME | VARCHAR2 | (40) | ||
SUPPLIER_NAME | VARCHAR2 | (255) | ||
SUPPLIER_SITE_NAME | VARCHAR2 | (40) | ||
ORDER_NUMBER | VARCHAR2 | (240) | ||
LINE_NUMBER | VARCHAR2 | (25) | ||
RELEASE_NUMBER | VARCHAR2 | (25) | ||
END_ORDER_NUMBER | VARCHAR2 | (240) | ||
END_ORDER_LINE_NUMBER | VARCHAR2 | (25) | ||
END_ORDER_REL_NUMBER | VARCHAR2 | (25) | ||
DESIGNATOR_OLD | VARCHAR2 | (100) | ||
DESIGNATOR_NEW | VARCHAR2 | (100) | ||
VERSION_OLD | VARCHAR2 | (240) | ||
VERSION_NEW | VARCHAR2 | (240) | ||
QUANTITY_OLD | NUMBER | |||
QUANTITY_NEW | NUMBER | |||
COMMENTS_OLD | VARCHAR2 | (1000) | ||
COMMENTS_NEW | VARCHAR2 | (1000) | ||
KEY_DATE_OLD | DATE | |||
KEY_DATE_NEW | DATE | |||
SHIP_DATE_OLD | DATE | |||
SHIP_DATE_NEW | DATE | |||
RECEIPT_DATE_OLD | DATE | |||
RECEIPT_DATE_NEW | DATE | |||
NEW_SCHEDULE_DATE_OLD | DATE | |||
NEW_SCHEDULE_DATE_NEW | DATE | |||
NEW_ORDER_PLACEMENT_DATE_OLD | DATE | |||
NEW_ORDER_PLACEMENT_DATE_NEW | DATE | |||
ORIGINAL_PROMISED_DATE_OLD | DATE | |||
ORIGINAL_PROMISED_DATE_NEW | DATE | |||
REQUEST_DATE_OLD | DATE | |||
REQUEST_DATE_NEW | DATE | |||
PLANNED_WIP_START_DATE_OLD | DATE | |||
PLANNED_WIP_START_DATE_NEW | DATE | |||
PLANNED_WIP_END_DATE_OLD | DATE | |||
PLANNED_WIP_END_DATE_NEW | DATE | |||
WIP_START_DATE_OLD | DATE | |||
WIP_START_DATE_NEW | DATE | |||
WIP_END_DATE_OLD | DATE | |||
WIP_END_DATE_NEW | DATE | |||
LAST_REFRESH_NUMBER_OLD | NUMBER | |||
LAST_REFRESH_NUMBER_NEW | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
DMLTYPE | VARCHAR2 | (1) | ||
ITEM_NAME | VARCHAR2 | (250) | ||
OWNER_ITEM_NAME | VARCHAR2 | (250) | ||
CUSTOMER_ITEM_NAME | VARCHAR2 | (250) | ||
SUPPLIER_ITEM_NAME | VARCHAR2 | (250) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
OWNER_ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
SUPPLIER_ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
CUSTOMER_ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
BUCKET_TYPE_NEW | NUMBER | |||
BUCKET_TYPE_OLD | NUMBER | |||
USE_FOR_COMPARISON | NUMBER |
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#;
|
|
|