JL_BR_AR_OCCURRENCE_DOCS_V

Details

• Schema: FUSION

• Object owner: JL

• Object type: VIEW

Columns

Name

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 OBJECT_VERSION_NUMBER COLL_BATCH_ID PAYMENT_SCHEDULE_ID

Query

SQL_Statement

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 ,JLOCC.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, JLOCC.COLL_BATCH_ID COLL_BATCH_ID,JLOCC.PAYMENT_SCHEDULE_ID 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)