[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
APPS.MSC_SUP_DEM_HISTORY_V is not referenced by any database object
|
|
|
|