Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JL_BR_AR_OCCURRENCE_DOCS_V

Object Details
Object Name: JL_BR_AR_OCCURRENCE_DOCS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJL.JL_BR_AR_OCCURRENCE_DOCS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
OCCURRENCE_ID NUMBER
Yes
DOCUMENT_ID NUMBER
Yes
BANK_OCCURRENCE_CODE NUMBER (2) Yes
BANK_PARTY_ID NUMBER (15) Yes
BANK_NUMBER VARCHAR2 (30)
BANK_OCCURRENCE_TYPE VARCHAR2 (30) Yes
OCCURRENCE_DATE DATE

OCCURRENCE_STATUS VARCHAR2 (30)
ORIGINAL_REMITTANCE_MEDIA VARCHAR2 (30)
REMITTANCE_MEDIA VARCHAR2 (30)
SELECTION_DATE DATE

BORDERO_ID NUMBER

PORTFOLIO_CODE NUMBER

TRADE_NOTE_NUMBER VARCHAR2 (20)
DUE_DATE DATE

DOCUMENT_AMOUNT NUMBER

BANK_INSTRUCTION_CODE1 NUMBER (2)
BANK_INSTRUCTION_CODE2 NUMBER (2)
NUM_DAYS_INSTRUCTION NUMBER

INTEREST_PERCENT NUMBER

INTEREST_PERIOD NUMBER

INTEREST_AMOUNT NUMBER

GRACE_DAYS NUMBER

DISCOUNT_LIMIT_DATE DATE

DISCOUNT_AMOUNT NUMBER

CUSTOMER_ID NUMBER (15)
SITE_USE_ID NUMBER (15)
ABATEMENT_AMOUNT NUMBER

FLAG_POST_GL VARCHAR2 (1)
GL_DATE DATE

GL_POSTED_DATE DATE

ENDORSEMENT_CREDIT_CCID NUMBER (15)
ENDORSEMENT_DEBIT_CCID NUMBER (15)
ENDORSEMENT_DEBIT_AMOUNT NUMBER

ENDORSEMENT_CREDIT_AMOUNT NUMBER

BANK_CHARGE_AMOUNT NUMBER

BANK_CHARGES_CREDIT_CCID NUMBER (15)
BANK_CHARGES_DEBIT_CCID NUMBER (15)
BANK_CHARGES_CREDIT_AMOUNT NUMBER

BANK_CHARGES_DEBIT_AMOUNT NUMBER

REQUEST_ID NUMBER (15)
RETURN_INFO VARCHAR2 (50)
INTEREST_INDICATOR VARCHAR2 (30)
RETURN_REQUEST_ID NUMBER (15)
GL_CANCEL_DATE DATE

ORG_ID NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
DESCRIPTION VARCHAR2 (240) Yes
REMITTANCE_DATE DATE

STD_OCCURRENCE_CODE VARCHAR2 (30) Yes
FACTORING_CHARGES_CREDIT_CCID NUMBER (15)
FACTORING_CHARGES_DEBIT_CCID NUMBER (15)
FACTORING_CHARGES_CRED_AMOUNT NUMBER

FACTORING_CHARGES_DEB_AMOUNT NUMBER

DISCOUNTED_BILLS_CREDIT_CCID NUMBER (15)
DISCOUNTED_BILLS_DEBIT_CCID NUMBER (15)
DISCOUNTED_BILLS_DEB_AMOUNT NUMBER

DISCOUNTED_BILLS_CRED_AMOUNT NUMBER

DISCOUNT_DEBIT_CCID NUMBER (15)
DISCOUNT_CREDIT_CCID NUMBER (15)
CASH_CREDIT_CCID NUMBER (15)
CASH_DEBIT_CCID NUMBER (15)
CASH_CRED_AMOUNT NUMBER

CASH_DEB_AMOUNT NUMBER

Query Text

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


SELECT ROW_ID
,      OCCURRENCE_ID
,      DOCUMENT_ID
,      BANK_OCCURRENCE_CODE
,      BANK_PARTY_ID
,      BANK_NUMBER
,      BANK_OCCURRENCE_TYPE
,      OCCURRENCE_DATE
,      OCCURRENCE_STATUS
,      ORIGINAL_REMITTANCE_MEDIA
,      REMITTANCE_MEDIA
,      SELECTION_DATE
,      BORDERO_ID
,      PORTFOLIO_CODE
,      TRADE_NOTE_NUMBER
,      DUE_DATE
,      DOCUMENT_AMOUNT
,      BANK_INSTRUCTION_CODE1
,      BANK_INSTRUCTION_CODE2
,      NUM_DAYS_INSTRUCTION
,      INTEREST_PERCENT
,      INTEREST_PERIOD
,      INTEREST_AMOUNT
,      GRACE_DAYS
,      DISCOUNT_LIMIT_DATE
,      DISCOUNT_AMOUNT
,      CUSTOMER_ID
,      SITE_USE_ID
,      ABATEMENT_AMOUNT
,      FLAG_POST_GL
,      GL_DATE
,      GL_POSTED_DATE
,      ENDORSEMENT_CREDIT_CCID
,      ENDORSEMENT_DEBIT_CCID
,      ENDORSEMENT_DEBIT_AMOUNT
,      ENDORSEMENT_CREDIT_AMOUNT
,      BANK_CHARGE_AMOUNT
,      BANK_CHARGES_CREDIT_CCID
,      BANK_CHARGES_DEBIT_CCID
,      BANK_CHARGES_CREDIT_AMOUNT
,      BANK_CHARGES_DEBIT_AMOUNT
,      REQUEST_ID
,      RETURN_INFO
,      INTEREST_INDICATOR
,      RETURN_REQUEST_ID
,      GL_CANCEL_DATE
,      ORG_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      REMITTANCE_DATE
,      STD_OCCURRENCE_CODE
,      FACTORING_CHARGES_CREDIT_CCID
,      FACTORING_CHARGES_DEBIT_CCID
,      FACTORING_CHARGES_CRED_AMOUNT
,      FACTORING_CHARGES_DEB_AMOUNT
,      DISCOUNTED_BILLS_CREDIT_CCID
,      DISCOUNTED_BILLS_DEBIT_CCID
,      DISCOUNTED_BILLS_DEB_AMOUNT
,      DISCOUNTED_BILLS_CRED_AMOUNT
,      DISCOUNT_DEBIT_CCID
,      DISCOUNT_CREDIT_CCID
,      CASH_CREDIT_CCID
,      CASH_DEBIT_CCID
,      CASH_CRED_AMOUNT
,      CASH_DEB_AMOUNT
FROM APPS.JL_BR_AR_OCCURRENCE_DOCS_V;

Dependencies

[top of page]

APPS.JL_BR_AR_OCCURRENCE_DOCS_V references the following:

SchemaAPPS
SynonymHZ_ORGANIZATION_PROFILES
SynonymHZ_PARTIES
SynonymJL_BR_AR_BANK_OCCURRENCES
SynonymJL_BR_AR_BORDEROS_ALL
SynonymJL_BR_AR_OCCURRENCE_DOCS_ALL

APPS.JL_BR_AR_OCCURRENCE_DOCS_V is not referenced by any database object