[Home] [Help] [Dependency Information]
Object Name: | EDW_GEOGRAPHY_M_OLD |
---|---|
Object Type: | TABLE |
Owner: | POA |
Subobject Name: | |
Status: | VALID |
EDW Geography dimension (obsoleted)
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_GEOGRAPHY_M_OLD_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | GLOC_LOCATION_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GLOC_LOCATION_PK_KEY | NUMBER | Yes | Global Location PK Key | |
GLOC_LOCATION_PK | VARCHAR2 | (240) | Global location PK | |
POSTCODE_CITY_PK | VARCHAR2 | (240) | Postcode City PK |
Cut, paste (and edit) the following text to query this object:
SELECT GLOC_LOCATION_PK_KEY
, GLOC_LOCATION_PK
, POSTCODE_CITY_PK
FROM POA.EDW_GEOGRAPHY_M_OLD;
POA.EDW_GEOGRAPHY_M_OLD does not reference any database object
POA.EDW_GEOGRAPHY_M_OLD is referenced by following:
|
|
|