[Home] [Help] [Dependency Information]
Object Name: | EDW_DUNS_DOMESTIC_LTC |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.EDW_DUNS_DOMESTIC_LTC |
Subobject Name: | |
Status: | VALID |
This is the Domestic Ultimate level table in the DUNS Dimension. This table stores the site DUNS number and address information of DUNS sites that are domestic ultimates of other DUNS sites.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_DUNS_DOMESTIC_LTC_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | DOMESTIC_ULT_PK_KEY |
EDW_DUNS_DOMESTIC_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
DOMESTIC_ULT_PK
DOMESTIC_ULT_PK_KEY |
EDW_DUNS_DOMESTIC_LTC_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | GLOBAL_ULT_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GLOBAL_ULT_FK_KEY | NUMBER | System generated foreign key to the Global Ultimate dimension level | ||
DOMESTIC_ULT_PK_KEY | NUMBER | System generated unique identifier for the Domestic 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. | |
NAME | VARCHAR2 | (160) | Name of record for the Domestic Ultimate. The Domestic Ultimate is the ultimate parent company within the same country as the business site. | |
INSTANCE | VARCHAR2 | (40) | Source database instance for DUNS Domestic. | |
GLOBAL_ULT_FK | VARCHAR2 | (40) | Foreign key to the Global Ultimate level | |
DUNS_NUMBER | VARCHAR2 | (40) | D&B unique number for the business site | |
DOMESTIC_ULT_PK | VARCHAR2 | (40) | Unique identifier for Domestic Ultimate | |
DOMESTIC_ULT_DP | VARCHAR2 | (160) | Unique Domestic Ultimate name | |
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 GLOBAL_ULT_FK_KEY
, DOMESTIC_ULT_PK_KEY
, USER_ATTRIBUTE5
, USER_ATTRIBUTE4
, USER_ATTRIBUTE3
, USER_ATTRIBUTE2
, USER_ATTRIBUTE1
, TELEPHONE
, STATE_PROV
, POSTAL_CODE
, NAME
, INSTANCE
, GLOBAL_ULT_FK
, DUNS_NUMBER
, DOMESTIC_ULT_PK
, DOMESTIC_ULT_DP
, COUNTRY
, CITY
, ADDRESS
, LAST_UPDATE_DATE
, CREATION_DATE
FROM POA.EDW_DUNS_DOMESTIC_LTC;
POA.EDW_DUNS_DOMESTIC_LTC does not reference any database object
POA.EDW_DUNS_DOMESTIC_LTC is referenced by following:
|
|
|