DBA Data[Home] [Help] [Dependency Information]

TABLE: DDR.DDR_R_ADDR_LOC

Object Details
Object Name: DDR_R_ADDR_LOC
Object Type: TABLE
Owner: DDR
Subobject Name:
Status: VALID


Stores address for an individual location


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDR_R_ADDR_LOC_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnADDR_LOC_ID
Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30) Yes Manufacturer Organization Code
ADDR_LOC_ID NUMBER
Yes Address Location ID
ADDR_LOC_CD VARCHAR2 (30) Yes Address Location Code
ADDR_LINE_1 VARCHAR2 (240) Yes Line 1 of the detail postal address
ADDR_LINE_2 VARCHAR2 (240)
Line 2 of the detailed postal address
ADDR_LINE_3 VARCHAR2 (240)
Line 3 of the detailed postal address
ADDR_DESC VARCHAR2 (240)
Address description
ADDR_LINE_PHNTC VARCHAR2 (240)
Phonetic or Kana representation of the Kanji address lines (used in Japan)
TIME_ZN_CD VARCHAR2 (30)
Time Zone. Location in the world relative to Greenwich Mean Time Zone
LAT VARCHAR2 (40)
Latitude
LON VARCHAR2 (40)
Longitude
ELVTN NUMBER

Elevation
ELVTN_UOM_CD VARCHAR2 (30)
Unit of measurement for the Elevation.
ADDR_TYP_CD VARCHAR2 (30)
Address Type
CNTRY_CD VARCHAR2 (30)
Country Code
CNTRY_NAME VARCHAR2 (40)
Country Name
GEO_RGN_ID NUMBER

Geographic Region ID
RGN_CD VARCHAR2 (30)
Geographical Region Code
RGN_NAME VARCHAR2 (40)
Geographical Region Name
GEO_SUB_RGN_ID NUMBER

Geographic Sub Region ID
SUB_RGN_CD VARCHAR2 (30)
Geographical Sub Region Code
SUB_RGN_NAME VARCHAR2 (40)
Geographical Sub Region Name
STATE_CD VARCHAR2 (30)
State code
STATE_NAME VARCHAR2 (40)
State name
CITY_CD VARCHAR2 (30)
City code
CITY_NAME VARCHAR2 (40)
City name
POST_CD VARCHAR2 (30)
Postal Code (Zip Code)
POST_OFFC_BOX VARCHAR2 (30)
Post Office Box
GEO_CD VARCHAR2 (30)
Geographic Code
GEO_DEMOG_ID NUMBER

Demographic ID
ALT_GEO_DEMOG_ID NUMBER

Alternate Demographic ID
ALT_GEO_CD VARCHAR2 (30)
Alternate Geographic Code
PRMRY_ADDR_PHONE VARCHAR2 (40)
Primary Address Phone
PRMRY_EMAIL_ADDR VARCHAR2 (255)
Primary E-mail Address
EFF_FROM_DT DATE
Yes Effective From Date
EFF_TO_DT DATE

Effective To Date
SRC_SYS_IDNT VARCHAR2 (40) Yes Source file name or system that provided the data. It can be used to cross-reference the data with the source system, mainly for auditing purpose
SRC_SYS_DT DATE
Yes The date that the data was created. It can be used to cross-reference the data with the source system, mainly for auditing purpose
CRTD_BY_DSR VARCHAR2 (30) Yes User Information of who loaded the data, for auditing purpose
LAST_UPDT_BY_DSR VARCHAR2 (30) Yes User Information of last updated by, for auditing purpose
CREATED_BY NUMBER (15) Yes Number code of who last loaded the data, for auditing purpose
CREATION_DATE DATE
Yes Date on which the data was loaded in target table, for auditing purpose
LAST_UPDATED_BY NUMBER (15) Yes Number code of who last updated the data in target table, for auditing purpose
LAST_UPDATE_DATE DATE
Yes Date on which the data was last updated in target table, for auditing purpose
LAST_UPDATE_LOGIN NUMBER (15) Yes Login ID of the User who last updated the data in target table, for auditing purpose
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MFG_ORG_CD
,      ADDR_LOC_ID
,      ADDR_LOC_CD
,      ADDR_LINE_1
,      ADDR_LINE_2
,      ADDR_LINE_3
,      ADDR_DESC
,      ADDR_LINE_PHNTC
,      TIME_ZN_CD
,      LAT
,      LON
,      ELVTN
,      ELVTN_UOM_CD
,      ADDR_TYP_CD
,      CNTRY_CD
,      CNTRY_NAME
,      GEO_RGN_ID
,      RGN_CD
,      RGN_NAME
,      GEO_SUB_RGN_ID
,      SUB_RGN_CD
,      SUB_RGN_NAME
,      STATE_CD
,      STATE_NAME
,      CITY_CD
,      CITY_NAME
,      POST_CD
,      POST_OFFC_BOX
,      GEO_CD
,      GEO_DEMOG_ID
,      ALT_GEO_DEMOG_ID
,      ALT_GEO_CD
,      PRMRY_ADDR_PHONE
,      PRMRY_EMAIL_ADDR
,      EFF_FROM_DT
,      EFF_TO_DT
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      CRTD_BY_DSR
,      LAST_UPDT_BY_DSR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM DDR.DDR_R_ADDR_LOC;

Dependencies

[top of page]

DDR.DDR_R_ADDR_LOC does not reference any database object

DDR.DDR_R_ADDR_LOC is referenced by following:

SchemaAPPS
SynonymDDR_R_ADDR_LOC