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]

TABLE: AR.AR_IREC_USER_ACCT_SITES_ALL

Object Details

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

This table stores the current session ID, current date and a list of all Org IDs with their corresponding customers IDs and customer site IDs accessible by the current user.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_IREC_USER_ACCT_SITES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID SESSION_ID USER_ID CUSTOMER_ID CUSTOMER_SITE_USE_ID
AR_IREC_USER_ACCT_SITES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_SITE_USE_ID USER_ID SESSION_ID CUSTOMER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER	(15)	Yes	Organization Id
SESSION_ID	NUMBER	(15)	Yes	Session Id
USER_ID	NUMBER	(15)	Yes	User Id
CUSTOMER_ID	NUMBER	(15)	Yes	Customer Id
CUSTOMER_SITE_USE_ID	NUMBER	(15)	Yes	Customer Site Use Id
CURRENT_DATE	DATE			Current Date
CREATED_BY	NUMBER	(15)		Created By
CREATION_DATE	DATE			Creation Date
LAST_UPDATED_BY	NUMBER	(15)		Last Updated By
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Update Login
LAST_UPDATE_DATE	DATE			Last Update Date
OBJECT_VERSION_NUMBER	NUMBER			Standard HTML front end column
RELATED_CUSTOMER_FLAG	VARCHAR2	(1)		Related Customer Flag

Query Text

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


SELECT ORG_ID
,      SESSION_ID
,      USER_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      CURRENT_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      RELATED_CUSTOMER_FLAG
FROM AR.AR_IREC_USER_ACCT_SITES_ALL;

Dependencies

[top of page]

AR.AR_IREC_USER_ACCT_SITES_ALL does not reference any database object

AR.AR_IREC_USER_ACCT_SITES_ALL is referenced by following:

AR: AR_IREC_USER_ACCT_SITES_ALL#