[Home] [Help] [Dependency Information]
Object Name: | MSC_SUP_DEM_HISTORY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSC.MSC_SUP_DEM_HISTORY_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HISTORY_ID | NUMBER | |||
FROMCOMPORG | VARCHAR2 | (297) | ||
TOCOMPORG | VARCHAR2 | (297) | ||
CUSTOMER_NAME | VARCHAR2 | (255) | ||
CUSTOMER_SITE_NAME | VARCHAR2 | (40) | ||
CUSTOMER_ITEM_NAME | VARCHAR2 | (250) | ||
CUSTOMER_ITEM_DESC | VARCHAR2 | (240) | ||
SUPPLIER_NAME | VARCHAR2 | (255) | ||
SUPPLIER_SITE_NAME | VARCHAR2 | (40) | ||
SUPPLIER_ITEM_NAME | VARCHAR2 | (250) | ||
SUPPLIER_ITEM_DESC | VARCHAR2 | (240) | ||
ITEM_NAME | VARCHAR2 | (250) | ||
ITEM_DESC | VARCHAR2 | (240) | ||
OWNER_ITEM_NAME | VARCHAR2 | (250) | ||
OWNER_ITEM_DESC | VARCHAR2 | (240) | ||
PUBLISHER_ORDER_TYPE | NUMBER | |||
PUBLISHER_ORDER_TYPE_DESC | VARCHAR2 | (80) | ||
DESIGNATOR | VARCHAR2 | (100) | ||
VERSION | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | |||
QUANTITY | NUMBER | |||
KEY_DATE_NEW | DATE | |||
SHIP_DATE | DATE | |||
RECEIPT_DATE | DATE | |||
NEW_SCHEDULE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT HISTORY_ID
, FROMCOMPORG
, TOCOMPORG
, CUSTOMER_NAME
, CUSTOMER_SITE_NAME
, CUSTOMER_ITEM_NAME
, CUSTOMER_ITEM_DESC
, SUPPLIER_NAME
, SUPPLIER_SITE_NAME
, SUPPLIER_ITEM_NAME
, SUPPLIER_ITEM_DESC
, ITEM_NAME
, ITEM_DESC
, OWNER_ITEM_NAME
, OWNER_ITEM_DESC
, PUBLISHER_ORDER_TYPE
, PUBLISHER_ORDER_TYPE_DESC
, DESIGNATOR
, VERSION
, LAST_UPDATE_DATE
, QUANTITY
, KEY_DATE_NEW
, SHIP_DATE
, RECEIPT_DATE
, NEW_SCHEDULE_DATE
FROM APPS.MSC_SUP_DEM_HISTORY_V;
APPS.MSC_SUP_DEM_HISTORY_V is not referenced by any database object
|
|
|