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_BORDEROS_ALL

Object Details

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

JL_BR_AR_BORDEROS_ALL stores bank transfer and remittance batches.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_BR_AR_BORDEROS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BORDERO_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BORDERO_ID	NUMBER		Yes	Bank Transfer Batch identifier
SELECTION_CONTROL_ID	NUMBER		Yes	Selection Control identifier
BANK_ACCOUNT_ID	NUMBER			Bank Account identifier
BORDERO_STATUS	VARCHAR2	(30)	Yes	Lookup Code for Lookup Type JLBR_AR_BORDERO_STATUS.
SEQUENTIAL_NUMBER_GENERATION	NUMBER			Sequential Number for Remittance Batch generation
BORDERO_TYPE	VARCHAR2	(30)		Bank Transfer Batch Type
TOTAL_COUNT	NUMBER			Total number of documents in batch
TOTAL_AMOUNT	NUMBER			Total amount of documents in batch
SELECTION_DATE	DATE			Selection Date
REMITTANCE_DATE	DATE			Remittance Date
REFUSED_DATE	DATE			Refused Date
CANCELLATION_DATE	DATE			Cancellation Date
COLLECTION_DATE	DATE			Collection Date
WRITE_OFF_DATE	DATE			Write off Date
DATE_IN_RECEIPT	DATE			Date in Receipt
RECEIVED_DATE	DATE			Received Date
OUTPUT_PROGRAM_ID	NUMBER	(15)		Program identifier of the program used to format the batch
SELECT_ACCOUNT_ID	NUMBER			Account Selection Control Identifier
OUTPUT_FORMAT	VARCHAR2	(30)		Lookup Code for Lookup Type JLBR_AR_REMITTANCE MEDIA
ORG_ID	NUMBER	(15)		Operating Unit Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
BANK_ACCT_USE_ID	NUMBER	(15)	Yes	Uniquely identifies the bank account uses

Query Text

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


SELECT BORDERO_ID
,      SELECTION_CONTROL_ID
,      BANK_ACCOUNT_ID
,      BORDERO_STATUS
,      SEQUENTIAL_NUMBER_GENERATION
,      BORDERO_TYPE
,      TOTAL_COUNT
,      TOTAL_AMOUNT
,      SELECTION_DATE
,      REMITTANCE_DATE
,      REFUSED_DATE
,      CANCELLATION_DATE
,      COLLECTION_DATE
,      WRITE_OFF_DATE
,      DATE_IN_RECEIPT
,      RECEIVED_DATE
,      OUTPUT_PROGRAM_ID
,      SELECT_ACCOUNT_ID
,      OUTPUT_FORMAT
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      BANK_ACCT_USE_ID
FROM JL.JL_BR_AR_BORDEROS_ALL;

Dependencies

[top of page]

JL.JL_BR_AR_BORDEROS_ALL does not reference any database object

JL.JL_BR_AR_BORDEROS_ALL is referenced by following:

APPS: JL_BR_AR_BORDEROS; JL_BR_AR_BORDEROS_ALL