[Home] [Help] [Dependency Information]
Object Name: | JL_BR_AR_COLL_OCC_DOCS_H_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JL.JL_BR_AR_COLL_OCC_DOCS_H_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) | Operating Unit identifier | |
JLBR_DOCUMENT_ID | NUMBER | Collection Document identifier | ||
JLBR_OCCURRENCE_ID | NUMBER | Occurrence identifier | ||
JLBR_DOCUMENT_NUMBER | NUMBER | Collection Document identifier | ||
JLBR_RECEIPT_METHOD_ID | NUMBER | (15) | Receipt Method ID | |
JLBR_BANK_ACCT_USE_ID | NUMBER | (15) | Uniquely identifies the bank account uses | |
JLBR_OCC_DATE | DATE | |||
JLBR_TRADE_NOTE_NUMBER | VARCHAR2 | (61) | ||
JLBR_GL_DATE | DATE | |||
JLBR_BANK_OCC_CODE | NUMBER | |||
JLBR_BANK_OCC_DESC | VARCHAR2 | (240) | ||
JLBR_TRANSFER_TO_GL_FLAG | VARCHAR2 | (1) | ||
EVENT_ID | NUMBER | |||
JLBR_EXCHG_LOSS_CCID | NUMBER | (15) | ||
JLBR_EXCHG_GAIN_CCID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, JLBR_DOCUMENT_ID
, JLBR_OCCURRENCE_ID
, JLBR_DOCUMENT_NUMBER
, JLBR_RECEIPT_METHOD_ID
, JLBR_BANK_ACCT_USE_ID
, JLBR_OCC_DATE
, JLBR_TRADE_NOTE_NUMBER
, JLBR_GL_DATE
, JLBR_BANK_OCC_CODE
, JLBR_BANK_OCC_DESC
, JLBR_TRANSFER_TO_GL_FLAG
, EVENT_ID
, JLBR_EXCHG_LOSS_CCID
, JLBR_EXCHG_GAIN_CCID
FROM APPS.JL_BR_AR_COLL_OCC_DOCS_H_V;
|
|
|