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

VIEW: APPS.JL_BR_AR_OCC_DOCS_MRC_V

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

View Type

A multiple reporting currency view

[View Source]

Columns
Name Datatype Length Mandatory Comments
OCCURRENCE_ID NUMBER
Yes Occurrence identifier
DOCUMENT_ID NUMBER
Yes Collection Document identifier
BANK_OCCURRENCE_CODE NUMBER (2) Yes Bank occurrence code
BANK_PARTY_ID NUMBER (15) Yes Party identifier of bank
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

DISCOUNT_CRED_ACCT_CCID NUMBER (15)
FACTORING_DEBIT_CCID NUMBER (15)
FACTORING_CREDIT_CCID NUMBER (15)
FACTORING_CREDIT_AMOUNT NUMBER

FACTORING_DEBIT_AMOUNT NUMBER

FACTOR_INTEREST_CREDIT_CCID NUMBER (15)
FACTOR_INTEREST_DEBIT_CCID NUMBER (15)
FACTOR_INTEREST_DEBIT_AMOUNT NUMBER

FACTOR_INTEREST_CREDIT_AMOUNT NUMBER

REVERSE_CHARGES_CRED_CCID NUMBER (15)
REVERSE_CHARGES_DEB_CCID NUMBER (15)
REVERSE_CHARGES_DEB_AMOUNT NUMBER

REVERSE_CHARGES_CRED_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)
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_CRED_AMOUNT NUMBER

DISCOUNTED_BILLS_DEB_AMOUNT NUMBER

DISCOUNT_CREDIT_CCID NUMBER (15)
DISCOUNT_DEBIT_CCID NUMBER (15)
DISCOUNT_CRED_AMOUNT NUMBER

DISCOUNT_DEB_AMOUNT NUMBER

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 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
,      DISCOUNT_CRED_ACCT_CCID
,      FACTORING_DEBIT_CCID
,      FACTORING_CREDIT_CCID
,      FACTORING_CREDIT_AMOUNT
,      FACTORING_DEBIT_AMOUNT
,      FACTOR_INTEREST_CREDIT_CCID
,      FACTOR_INTEREST_DEBIT_CCID
,      FACTOR_INTEREST_DEBIT_AMOUNT
,      FACTOR_INTEREST_CREDIT_AMOUNT
,      REVERSE_CHARGES_CRED_CCID
,      REVERSE_CHARGES_DEB_CCID
,      REVERSE_CHARGES_DEB_AMOUNT
,      REVERSE_CHARGES_CRED_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
,      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_CRED_AMOUNT
,      DISCOUNTED_BILLS_DEB_AMOUNT
,      DISCOUNT_CREDIT_CCID
,      DISCOUNT_DEBIT_CCID
,      DISCOUNT_CRED_AMOUNT
,      DISCOUNT_DEB_AMOUNT
,      CASH_CREDIT_CCID
,      CASH_DEBIT_CCID
,      CASH_CRED_AMOUNT
,      CASH_DEB_AMOUNT
FROM APPS.JL_BR_AR_OCC_DOCS_MRC_V;

Dependencies

[top of page]

APPS.JL_BR_AR_OCC_DOCS_MRC_V references the following:

SchemaAPPS
SynonymHZ_ORGANIZATION_PROFILES
SynonymHZ_PARTIES
SynonymJL_BR_AR_MC_OCC_DOCS
SynonymJL_BR_AR_OCCURRENCE_DOCS_ALL

APPS.JL_BR_AR_OCC_DOCS_MRC_V is not referenced by any database object