eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ICX_RA_ADDRESSES_V

Product:	ICX - Oracle iProcurement
Description:	Obsolete
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.ADDRESS_ID
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.CUSTOMER_ID
, A.STATUS
, A.ORIG_SYSTEM_REFERENCE
, A.COUNTRY
, A.ADDRESS1
, A.ADDRESS2
, A.ADDRESS3
, A.ADDRESS4
, A.CITY
, A.POSTAL_CODE
, A.STATE
, A.PROVINCE
, A.COUNTY
, A.LAST_UPDATE_LOGIN
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.TERRITORY_ID
, A.ADDRESS_KEY
, A.BILL_TO_FLAG
, A.MARKET_FLAG
, A.SHIP_TO_FLAG
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.LOCATION_ID
, A.SERVICE_TERRITORY_ID
, A.PRIMARY_SPECIALIST_ID
, A.SECONDARY_SPECIALIST_ID
, C.CUSTOMER_PROSPECT_CODE
, A.CUSTOMER_CATEGORY_CODE
, A.CUSTOMER_GROUP_CODE
, A.CUSTOMER_SUBGROUP_CODE
, A.REFERENCE_USE_FLAG
, A.ANALYSIS_FY
, A.FISCAL_YEAREND_MONTH
, A.NET_WORTH
, A.NUM_OF_EMPLOYEES
, A.POTENTIAL_REVENUE_CURR_FY
, A.POTENTIAL_REVENUE_NEXT_FY
, A.RANK
, A.COMPETITOR_FLAG
, A.THIRD_PARTY_FLAG
, A.YEAR_ESTABLISHED
, A.DO_NOT_MAIL_FLAG
, A.ORG_ID
, A.ADDRESS_STYLE
, A.KEY_ACCOUNT_FLAG
, A.LANGUAGE
, A.ADDRESS_LINES_PHONETIC
FROM RA_ADDRESSES A
, RA_CUSTOMERS C
WHERE A.CUSTOMER_ID = C.CUSTOMER_ID(+)

Columns

Name
ADDRESS_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
CUSTOMER_ID
STATUS
ORIG_SYSTEM_REFERENCE
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_PROSPECT_CODE
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
ORG_ID
ADDRESS_STYLE
KEY_ACCOUNT_FLAG
LANGUAGE
ADDRESS_LINES_PHONETIC