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: JL.JL_BR_AR_RET_INTERFACE_TMP

Object Details

Object Name:	JL_BR_AR_RET_INTERFACE_TMP
Object Type:	TABLE
Owner:	JL
FND Design Data:	JL.JL_BR_AR_RET_INTERFACE_TMP
Subobject Name:
Status:	VALID

JL_BR_AR_RET_INTERFACE_TMP is a temporary table for the Brazilian Receivables Post Bank Return report.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_BR_AR_RET_INTERFACE_TMP_U1	NORMAL	UNIQUE	APPS_TS_NOLOGGING	RETURN_REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RETURN_REQUEST_ID	NUMBER	(15)	Yes	Return Concurrent request ID
ABATEMENT_TOTAL_NUMBER	NUMBER			Number of Abatements
ABATEMENT_TOTAL_EXPECTED	NUMBER			Expected Abatement Amount
ABATEMENT_TOTAL_RECEIVED	NUMBER			Total Abatement Amount Received
ABATEMENT_ADJ_AMOUNT	NUMBER			Abatement Adjustment Amount
INTEREST_TOTAL_NUMBER	NUMBER			Number of Interest
INTEREST_TOTAL_EXPECTED	NUMBER			Interest Calculated Amount
INTEREST_TOTAL_RECEIVED	NUMBER			Total Interest Amount Received
INTEREST_DM_AMOUNT	NUMBER			Total Interest Debit Memos Amount
INTEREST_ADJ_AMOUNT	NUMBER			Adjustment Amount created for interest
DISCOUNT_TOTAL_NUMBER	NUMBER			Number of Discounts
DISCOUNT_TOTAL_EXPECTED	NUMBER			Discount Calculated
DISCOUNT_TOTAL_RECEIVED	NUMBER			Discount Received
BANK_NUMBER	VARCHAR2	(30)		Bank Number to identify bank
BANK_PARTY_ID	NUMBER	(15)		Bank's party identifier

Query Text

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


SELECT RETURN_REQUEST_ID
,      ABATEMENT_TOTAL_NUMBER
,      ABATEMENT_TOTAL_EXPECTED
,      ABATEMENT_TOTAL_RECEIVED
,      ABATEMENT_ADJ_AMOUNT
,      INTEREST_TOTAL_NUMBER
,      INTEREST_TOTAL_EXPECTED
,      INTEREST_TOTAL_RECEIVED
,      INTEREST_DM_AMOUNT
,      INTEREST_ADJ_AMOUNT
,      DISCOUNT_TOTAL_NUMBER
,      DISCOUNT_TOTAL_EXPECTED
,      DISCOUNT_TOTAL_RECEIVED
,      BANK_NUMBER
,      BANK_PARTY_ID
FROM JL.JL_BR_AR_RET_INTERFACE_TMP;

Dependencies

[top of page]

JL.JL_BR_AR_RET_INTERFACE_TMP does not reference any database object

JL.JL_BR_AR_RET_INTERFACE_TMP is referenced by following:

APPS: JL_BR_AR_RET_INTERFACE_TMP