[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
|
|
|