View: JL_BR_AR_OCCURRENCE_DOCS_V

Product:	JL - Latin America Localizations
Description:
Implementation/DBA Data:	APPS.JL_BR_AR_OCCURRENCE_DOCS_V

View Text

SELECT JLOCC.ROWID ROW_ID
, JLOCC.OCCURRENCE_ID OCCURRENCE_ID
, JLOCC.DOCUMENT_ID DOCUMENT_ID
, JLOCC.BANK_OCCURRENCE_CODE BANK_OCCURRENCE_CODE
, JLOCC.BANK_PARTY_ID BANK_PARTY_ID
, BANKPROFILE.BANK_OR_BRANCH_NUMBER BANK_NUMBER
, JLOCC.BANK_OCCURRENCE_TYPE BANK_OCCURRENCE_TYPE
, JLOCC.OCCURRENCE_DATE OCCURRENCE_DATE
, JLOCC.OCCURRENCE_STATUS OCCURRENCE_STATUS
, JLOCC.ORIGINAL_REMITTANCE_MEDIA ORIGINAL_REMITTANCE_MEDIA
, JLOCC.REMITTANCE_MEDIA REMITTANCE_MEDIA
, JLOCC.SELECTION_DATE SELECTION_DATE
, JLOCC.BORDERO_ID BORDERO_ID
, JLOCC.PORTFOLIO_CODE PORTFOLIO_CODE
, JLOCC.TRADE_NOTE_NUMBER TRADE_NOTE_NUMBER
, JLOCC.DUE_DATE DUE_DATE
, JLOCC.DOCUMENT_AMOUNT DOCUMENT_AMOUNT
, JLOCC.BANK_INSTRUCTION_CODE1 BANK_INSTRUCTION_CODE1
, JLOCC.BANK_INSTRUCTION_CODE2 BANK_INSTRUCTION_CODE2
, JLOCC.NUM_DAYS_INSTRUCTION NUM_DAYS_INSTRUCTION
, JLOCC.INTEREST_PERCENT INTEREST_PERCENT
, JLOCC.INTEREST_PERIOD INTEREST_PERIOD
, JLOCC.INTEREST_AMOUNT INTEREST_AMOUNT
, JLOCC.GRACE_DAYS GRACE_DAYS
, JLOCC.DISCOUNT_LIMIT_DATE DISCOUNT_LIMIT_DATE
, JLOCC.DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, JLOCC.CUSTOMER_ID CUSTOMER_ID
, JLOCC.SITE_USE_ID SITE_USE_ID
, JLOCC.ABATEMENT_AMOUNT ABATEMENT_AMOUNT
, JLOCC.FLAG_POST_GL FLAG_POST_GL
, JLOCC.GL_DATE GL_DATE
, JLOCC.GL_POSTED_DATE GL_POSTED_DATE
, JLOCC.ENDORSEMENT_CREDIT_CCID ENDORSEMENT_CREDIT_CCID
, JLOCC.ENDORSEMENT_DEBIT_CCID ENDORSEMENT_DEBIT_CCID
, JLOCC.ENDORSEMENT_DEBIT_AMOUNT ENDORSEMENT_DEBIT_AMOUNT
, JLOCC.ENDORSEMENT_CREDIT_AMOUNT ENDORSEMENT_CREDIT_AMOUNT
, JLOCC.BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT
, JLOCC.BANK_CHARGES_CREDIT_CCID BANK_CHARGES_CREDIT_CCID
, JLOCC.BANK_CHARGES_DEBIT_CCID BANK_CHARGES_DEBIT_CCID
, JLOCC.BANK_CHARGES_CREDIT_AMOUNT BANK_CHARGES_CREDIT_AMOUNT
, JLOCC.BANK_CHARGES_DEBIT_AMOUNT BANK_CHARGES_DEBIT_AMOUNT
, JLOCC.REQUEST_ID REQUEST_ID
, JLOCC.RETURN_INFO RETURN_INFO
, JLOCC.INTEREST_INDICATOR INTEREST_INDICATOR
, JLOCC.RETURN_REQUEST_ID RETURN_REQUEST_ID
, JLOCC.GL_CANCEL_DATE GL_CANCEL_DATE
, JLOCC.ORG_ID ORG_ID
, JLOCC.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, JLOCC.ATTRIBUTE1 ATTRIBUTE1
, JLOCC.ATTRIBUTE2 ATTRIBUTE2
, JLOCC.ATTRIBUTE3 ATTRIBUTE3
, JLOCC.ATTRIBUTE4 ATTRIBUTE4
, JLOCC.ATTRIBUTE5 ATTRIBUTE5
, JLOCC.ATTRIBUTE6 ATTRIBUTE6
, JLOCC.ATTRIBUTE7 ATTRIBUTE7
, JLOCC.ATTRIBUTE8 ATTRIBUTE8
, JLOCC.ATTRIBUTE9 ATTRIBUTE9
, JLOCC.ATTRIBUTE10 ATTRIBUTE10
, JLOCC.ATTRIBUTE11 ATTRIBUTE11
, JLOCC.ATTRIBUTE12 ATTRIBUTE12
, JLOCC.ATTRIBUTE13 ATTRIBUTE13
, JLOCC.ATTRIBUTE14 ATTRIBUTE14
, JLOCC.ATTRIBUTE15 ATTRIBUTE15
, JLOCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JLOCC.LAST_UPDATED_BY LAST_UPDATED_BY
, JLOCC.CREATION_DATE CREATION_DATE
, JLOCC.CREATED_BY CREATED_BY
, JLOCC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ABC.DESCRIPTION DESCRIPTION
, AB.REMITTANCE_DATE REMITTANCE_DATE
, ABC.STD_OCCURRENCE_CODE STD_OCCURRENCE_CODE
, JLOCC.FACTORING_CHARGES_CREDIT_CCID
, JLOCC.FACTORING_CHARGES_DEBIT_CCID
, JLOCC.FACTORING_CHARGES_CRED_AMOUNT
, JLOCC.FACTORING_CHARGES_DEB_AMOUNT
, JLOCC.DISCOUNTED_BILLS_CREDIT_CCID
, JLOCC.DISCOUNTED_BILLS_DEBIT_CCID
, JLOCC.DISCOUNTED_BILLS_DEB_AMOUNT
, JLOCC.DISCOUNTED_BILLS_CRED_AMOUNT
, JLOCC.DISCOUNT_DEBIT_CCID
, JLOCC.DISCOUNT_CREDIT_CCID
, JLOCC.CASH_CREDIT_CCID
, JLOCC.CASH_DEBIT_CCID
, JLOCC.CASH_CRED_AMOUNT
, JLOCC.CASH_DEB_AMOUNT
FROM JL_BR_AR_OCCURRENCE_DOCS_ALL JLOCC
, JL_BR_AR_BANK_OCCURRENCES ABC
, JL_BR_AR_BORDEROS_ALL AB
, HZ_PARTIES BANK
, HZ_ORGANIZATION_PROFILES BANKPROFILE
WHERE JLOCC.BANK_OCCURRENCE_CODE = ABC.BANK_OCCURRENCE_CODE
AND JLOCC.BANK_OCCURRENCE_TYPE = ABC.BANK_OCCURRENCE_TYPE
AND JLOCC.BANK_PARTY_ID = ABC.BANK_PARTY_ID
AND JLOCC.BORDERO_ID = AB.BORDERO_ID(+)
AND BANK.PARTY_ID = JLOCC.BANK_PARTY_ID
AND BANK.PARTY_ID = BANKPROFILE.PARTY_ID
AND SYSDATE BETWEEN TRUNC(BANKPROFILE. EFFECTIVE_START_DATE)
AND NVL(TRUNC(BANKPROFILE.EFFECTIVE_END_DATE)
, SYSDATE+1)

Columns