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]

VIEW: APPS.JL_BR_AR_COLL_DOC_DISTS_L_V

Object Details

Object Name:	JL_BR_AR_COLL_DOC_DISTS_L_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JL.JL_BR_AR_COLL_DOC_DISTS_L_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORG_ID	NUMBER	(15)	Yes
JLBR_DISTRIBUTION_ID	NUMBER	(15)	Yes
JLBR_DOCUMENT_ID	NUMBER	(15)	Yes
JLBR_OCCURRENCE_ID	NUMBER	(15)
JLBR_DISTRIBUTION_TYPE	VARCHAR2	(30)	Yes
JLBR_ENTERED_AMT	NUMBER		Yes
JLBR_ENTERED_CURRENCY_CODE	VARCHAR2	(30)	Yes
JLBR_ACCTD_AMT	NUMBER
JLBR_CONVERSION_RATE	NUMBER
JLBR_CONVERSION_DATE	DATE
JLBR_CONVERSION_RATE_TYPE	VARCHAR2	(30)
JLBR_ACCT_REVERSING_OPTN	VARCHAR2	(30)
JLBR_REVERSED_DIST_ID	NUMBER	(15)
JLBR_REVERSED_DIST_LINK_TYPE	VARCHAR2	(30)
JLBR_PRIOR_DIST_ID	NUMBER	(15)
JLBR_PRIOR_DIST_LINK_TYPE	VARCHAR2	(30)
JLBR_PRIOR_OCCURRENCE_ID	NUMBER	(15)
JLBR_PRIOR_DOCUMENT_ID	NUMBER	(15)
JLBR_DISTRIBUTION_LINK_TYPE	VARCHAR2	(30)	Yes
EVENT_ID	NUMBER	(15)
EVENT_DATE	DATE
JLBR_STD_OCC_CODE	VARCHAR2	(30)	Yes
JLBR_BORDERO_TYPE	VARCHAR2	(30)	Yes
JLBR_BANK_OCC_TYPE	VARCHAR2	(30)	Yes
LINE_NUMBER	NUMBER
JLBR_CD_BIL_UND_COLL_CCID	NUMBER
JLBR_CD_BIL_UND_DISC_CCID	NUMBER
JLBR_CD_COLL_ENDRSMNT_CCID	NUMBER
JLBR_CD_DISC_ENDRSMNT_CCID	NUMBER
JLBR_CD_BANK_CHARGES_CCID	NUMBER
JLBR_CD_FACT_CHARGES_CCID	NUMBER
JLBR_CD_CASH_CCID	NUMBER

Query Text

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


SELECT ORG_ID
,      JLBR_DISTRIBUTION_ID
,      JLBR_DOCUMENT_ID
,      JLBR_OCCURRENCE_ID
,      JLBR_DISTRIBUTION_TYPE
,      JLBR_ENTERED_AMT
,      JLBR_ENTERED_CURRENCY_CODE
,      JLBR_ACCTD_AMT
,      JLBR_CONVERSION_RATE
,      JLBR_CONVERSION_DATE
,      JLBR_CONVERSION_RATE_TYPE
,      JLBR_ACCT_REVERSING_OPTN
,      JLBR_REVERSED_DIST_ID
,      JLBR_REVERSED_DIST_LINK_TYPE
,      JLBR_PRIOR_DIST_ID
,      JLBR_PRIOR_DIST_LINK_TYPE
,      JLBR_PRIOR_OCCURRENCE_ID
,      JLBR_PRIOR_DOCUMENT_ID
,      JLBR_DISTRIBUTION_LINK_TYPE
,      EVENT_ID
,      EVENT_DATE
,      JLBR_STD_OCC_CODE
,      JLBR_BORDERO_TYPE
,      JLBR_BANK_OCC_TYPE
,      LINE_NUMBER
,      JLBR_CD_BIL_UND_COLL_CCID
,      JLBR_CD_BIL_UND_DISC_CCID
,      JLBR_CD_COLL_ENDRSMNT_CCID
,      JLBR_CD_DISC_ENDRSMNT_CCID
,      JLBR_CD_BANK_CHARGES_CCID
,      JLBR_CD_FACT_CHARGES_CCID
,      JLBR_CD_CASH_CCID
FROM APPS.JL_BR_AR_COLL_DOC_DISTS_L_V;