[Home] [Help] [Dependency Information]
Object Name: | MSD_SR_SUP_ALL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is obsolete. This source relationship view brings in the relationships between suppliers and all geographies.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEVEL_VALUE_PK | VARCHAR2 | (42) | Level Value PK. | |
LEVEL_VALUE | VARCHAR2 | (4000) | Level Value. | |
LEVEL_VALUE_DESC | VARCHAR2 | (240) | Level Value Description. | |
PARENT_VALUE_PK | VARCHAR2 | (40) | Parent Value PK. | |
PARENT_VALUE | VARCHAR2 | (4000) | Parent Value. | |
PARENT_VALUE_DESC | VARCHAR2 | (4000) | Parent Level Value Description. | |
ATTRIBUTE1 | VARCHAR2 | (0) | Attribute1 | |
ATTRIBUTE2 | VARCHAR2 | (0) | Attribute2 | |
ATTRIBUTE3 | VARCHAR2 | (0) | Attribute3 | |
ATTRIBUTE4 | VARCHAR2 | (0) | Attribute4 | |
ATTRIBUTE5 | VARCHAR2 | (0) | Attribute5 | |
SYSTEM_ATTRIBUTE1 | VARCHAR2 | (80) | Descriptive Flexfield segment. | |
SYSTEM_ATTRIBUTE2 | VARCHAR2 | (0) | Descriptive Flexfield segment. | |
DP_ENABLED_FLAG | NUMBER | This column is not in use. It was used to distinguish DP, SOP and EOL level values. |
Cut, paste (and edit) the following text to query this object:
SELECT LEVEL_VALUE_PK
, LEVEL_VALUE
, LEVEL_VALUE_DESC
, PARENT_VALUE_PK
, PARENT_VALUE
, PARENT_VALUE_DESC
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, SYSTEM_ATTRIBUTE1
, SYSTEM_ATTRIBUTE2
, DP_ENABLED_FLAG
FROM APPS.MSD_SR_SUP_ALL_V;
APPS.MSD_SR_SUP_ALL_V is not referenced by any database object
|
|
|