[Home] [Help] [Dependency Information]

TABLE: AR.RA_ADDRESSES_ALL

Object Details

Object Name:	RA_ADDRESSES_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.RA_ADDRESSES_ALL
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Primary Key: RA_ADDRESSES_ALL_PK

1. ADDRESS_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
RA_ADDRESSES_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ADDRESS_ID
RA_ADDRESSES_U2	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ORIG_SYSTEM_REFERENCE ORG_ID
RA_ADDRESSES_U3	NORMAL	UNIQUE	APPS_TS_ARCHIVE	TP_HEADER_ID
SYS_IL0000028300C00097$$	LOB	UNIQUE	APPS_TS_ARCHIVE
RA_ADDRESSES_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ADDRESS1
RA_ADDRESSES_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	CREATION_DATE
RA_ADDRESSES_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	CUSTOMER_ID
RA_ADDRESSES_N4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ADDRESS_KEY
RA_ADDRESSES_N5	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	POSTAL_CODE
RA_ADDRESSES_N6	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	COUNTRY STATE

Columns

Query Text

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

SELECT ADDRESS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      CUSTOMER_ID
,      STATUS
,      ORIG_SYSTEM_REFERENCE
,      ORG_ID
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TERRITORY_ID
,      ADDRESS_KEY
,      BILL_TO_FLAG
,      MARKET_FLAG
,      SHIP_TO_FLAG
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LOCATION_ID
,      SERVICE_TERRITORY_ID
,      PRIMARY_SPECIALIST_ID
,      SECONDARY_SPECIALIST_ID
,      CUSTOMER_CATEGORY_CODE
,      CUSTOMER_GROUP_CODE
,      CUSTOMER_SUBGROUP_CODE
,      REFERENCE_USE_FLAG
,      ANALYSIS_FY
,      FISCAL_YEAREND_MONTH
,      NET_WORTH
,      NUM_OF_EMPLOYEES
,      POTENTIAL_REVENUE_CURR_FY
,      POTENTIAL_REVENUE_NEXT_FY
,      RANK
,      COMPETITOR_FLAG
,      THIRD_PARTY_FLAG
,      YEAR_ESTABLISHED
,      DO_NOT_MAIL_FLAG
,      ADDRESS_STYLE
,      LANGUAGE
,      KEY_ACCOUNT_FLAG
,      TP_HEADER_ID
,      WH_UPDATE_DATE
,      ADDRESS_LINES_PHONETIC
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      ECE_TP_LOCATION_CODE
,      SALES_TAX_GEOCODE
,      SALES_TAX_INSIDE_CITY_LIMITS
,      TERRITORY
,      TRANSLATED_CUSTOMER_NAME
,      ADDRESS_TEXT
FROM AR.RA_ADDRESSES_ALL;

Dependencies

[top of page]

AR.RA_ADDRESSES_ALL does not reference any database object

AR.RA_ADDRESSES_ALL is referenced by following:

AR

RA_ADDRESSES_ALL#