VIEW: APPS.JL_BR_AR_OCCURRENCE_DOCS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)