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_BR_STATUS_SUM_ITF

Object Details

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

The AR_BR_STATUS_SUM_ITF table is an RXi interface table that contains data populated by the Bills Receivable by Status Summary report. Oracle Receivables purges this table only when you submit the Purge Data from RXi Interface Tables concurrent program. Until you submit this concurrent program, Receivables adds records to this table each time that the Bills Receivable by Status Summary report is run.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_BR_STATUS_SUM_ITF_N1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER	(15)	Yes	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_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.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
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).
STATUS	VARCHAR2	(80)		Status of the bills receivable
CURRENCY	VARCHAR2	(15)		Currency of the bills receivable
BALANCE_DUE	NUMBER			Current amount due
FUNCTIONAL_BALANCE_DUE	NUMBER			Current amount due in functional currency
TRANSACTION_TYPE	VARCHAR2	(20)		Transaction type
COUNT	NUMBER			Number of bills receivable included in summary
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)		Functional currency code
ORGANIZATION_NAME	VARCHAR2	(30)		Organization name

Query Text

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


SELECT REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      STATUS
,      CURRENCY
,      BALANCE_DUE
,      FUNCTIONAL_BALANCE_DUE
,      TRANSACTION_TYPE
,      COUNT
,      FUNCTIONAL_CURRENCY_CODE
,      ORGANIZATION_NAME
FROM AR.AR_BR_STATUS_SUM_ITF;

Dependencies

[top of page]

AR.AR_BR_STATUS_SUM_ITF does not reference any database object

AR.AR_BR_STATUS_SUM_ITF is referenced by following:

APPS: AR_BR_STATUS_SUM_ITF