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_FMT_TMP

Object Details

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

The AR_BR_FMT_TMP table is temporary table that Oracle Receivables uses to format and build the Spanish Bills Receivable reports before the reports are printed. The Spanish Bills Receivable reports are:
{{"bul:1"}}Spanish Bills Receivable CSB32 Remittance Format report
{{"bul:1"}}Spanish Bills Receivable CSB58 Remittance Format report
{{"bul:1"}}Spanish Bills Receivable Format report

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
BATCH_ID	NUMBER	(15)	Unique batch identifier for the report
BR_ID	NUMBER	(15)	Unique transaction identifier for the bills receivable that are included in the report
LINE_ID	NUMBER	(15)	Unique line identifier for the concurrent request
REQUEST_ID	NUMBER	(15)	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
FORMAT_TEXT	VARCHAR2	(240)	Bills receivable format data that appears in the report output

Query Text

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


SELECT BATCH_ID
,      BR_ID
,      LINE_ID
,      REQUEST_ID
,      FORMAT_TEXT
FROM AR.AR_BR_FMT_TMP;

Dependencies

[top of page]

AR.AR_BR_FMT_TMP does not reference any database object

AR.AR_BR_FMT_TMP is referenced by following:

AR: AR_BR_FMT_TMP#