[Home] [Help] [Dependency Information]
Object Name: | EDW_DUNS_PARENT_LTC |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.EDW_DUNS_PARENT_LTC |
Subobject Name: | |
Status: | VALID |
This is the Parent level table in the DUNS Dimension. This table stores the site DUNS number and address information of DUNS sites that are parents of other DUNS sites.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_DUNS_PARENT_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
PARENT_PK_KEY
PARENT_PK |
EDW_DUNS_PARENT_LTC_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | GLOBAL_ULT_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_PK_KEY | NUMBER | Unique identifier for the Parent level | ||
GLOBAL_ULT_FK_KEY | NUMBER | System generated foreign key to Global Ultimate level | ||
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
TELEPHONE | VARCHAR2 | (40) | Telephone number of record for the business site. | |
STATE_PROV | VARCHAR2 | (60) | State or provence of record for the business site. | |
POSTAL_CODE | VARCHAR2 | (40) | Postal Code of record for the business site. | |
PARENT_PK | VARCHAR2 | (40) | Unique identifier for Parent level | |
PARENT_DP | VARCHAR2 | (160) | Unique Parent name | |
NAME | VARCHAR2 | (160) | Name of record for the parent company | |
INSTANCE | VARCHAR2 | (40) | Source database instance for DUNS Global. | |
GLOBAL_ULT_FK | VARCHAR2 | (40) | Foreign key to the Global Ultimate dimension level | |
DUNS_NUMBER | VARCHAR2 | (40) | D&B unique number for the business site | |
COUNTRY | VARCHAR2 | (40) | Country of record for the business site. | |
CITY | VARCHAR2 | (60) | City of record for the business site. | |
ADDRESS | VARCHAR2 | (80) | Address of record for the business site. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
CREATION_DATE | DATE | Yes | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_PK_KEY
, GLOBAL_ULT_FK_KEY
, USER_ATTRIBUTE5
, USER_ATTRIBUTE4
, USER_ATTRIBUTE3
, USER_ATTRIBUTE2
, USER_ATTRIBUTE1
, TELEPHONE
, STATE_PROV
, POSTAL_CODE
, PARENT_PK
, PARENT_DP
, NAME
, INSTANCE
, GLOBAL_ULT_FK
, DUNS_NUMBER
, COUNTRY
, CITY
, ADDRESS
, LAST_UPDATE_DATE
, CREATION_DATE
FROM POA.EDW_DUNS_PARENT_LTC;
POA.EDW_DUNS_PARENT_LTC does not reference any database object
POA.EDW_DUNS_PARENT_LTC is referenced by following:
|
|
|