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.

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

VIEW: APPS.OE_RA_ADDRESSES_V

Object Details

Object Name:	OE_RA_ADDRESSES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_RA_ADDRESSES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is used for validation of addresses.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ADDRESS_ID	NUMBER	(15)	Yes	Customer site identifier
CUSTOMER_ID	NUMBER	(15)	Yes	Identifier for a customer account. Foreign key to the HZ_CUST_ACCOUNTS table
BILL_TO_FLAG	VARCHAR2	(1)		Indicates if this is a Bill-To site. Y for a Bill-To site, P for the primary Bill-To site, and N for a site that is not a Bill-To site.
SHIP_TO_FLAG	VARCHAR2	(1)		Indicates if this is a Ship-To site. Y for a Ship-To site, P for the primary Ship-To site, and N for a site that is not a Ship-To site.
STATUS	VARCHAR2	(1)	Yes	Customer Status flag. Receivables lookup code for CODE_STATUS
ORG_ID	NUMBER	(15)		Organization identifier
TERRITORY_ID	NUMBER	(15)		Identifier for the territory
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
SOLD_TO_ORG_ID	NUMBER	(15)	Yes	Identifier for a customer account. Foreign key to the HZ_CUST_ACCOUNTS table

Query Text

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


SELECT ADDRESS_ID
,      CUSTOMER_ID
,      BILL_TO_FLAG
,      SHIP_TO_FLAG
,      STATUS
,      ORG_ID
,      TERRITORY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SOLD_TO_ORG_ID
FROM APPS.OE_RA_ADDRESSES_V;

Dependencies

[top of page]

APPS.OE_RA_ADDRESSES_V references the following:

APPS: HZ_CUST_ACCT_SITES

APPS.OE_RA_ADDRESSES_V is not referenced by any database object