JL_BR_AR_OCC_DOCS_ALL_MRC

Details

Schema: FUSION
Object owner: JL
Object type: VIEW

Columns

Name
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 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 OBJECT_VERSION_NUMBER

Name

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

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

OBJECT_VERSION_NUMBER

Query

SQL_Statement
SELECT MC.OCCURRENCE_ID , OD.DOCUMENT_ID , OD.BANK_OCCURRENCE_CODE , OD.BANK_PARTY_ID , BANKPROFILE.BANK_OR_BRANCH_NUMBER BANK_NUMBER, OD.BANK_OCCURRENCE_TYPE , OD.OCCURRENCE_DATE , OD.OCCURRENCE_STATUS , OD.ORIGINAL_REMITTANCE_MEDIA , OD.REMITTANCE_MEDIA , OD.SELECTION_DATE , OD.BORDERO_ID , OD.PORTFOLIO_CODE , OD.TRADE_NOTE_NUMBER , OD.DUE_DATE, OD.DOCUMENT_AMOUNT, OD.BANK_INSTRUCTION_CODE1 , OD.BANK_INSTRUCTION_CODE2 , OD.NUM_DAYS_INSTRUCTION , OD.INTEREST_PERCENT , OD.INTEREST_PERIOD , OD.INTEREST_AMOUNT , OD.GRACE_DAYS , OD.DISCOUNT_LIMIT_DATE , OD.DISCOUNT_AMOUNT , OD.CUSTOMER_ID , OD.SITE_USE_ID , OD.ABATEMENT_AMOUNT , MC.FLAG_POST_GL , OD.GL_DATE , MC.GL_POSTED_DATE , OD.ENDORSEMENT_CREDIT_CCID , OD.ENDORSEMENT_DEBIT_CCID , OD.ENDORSEMENT_DEBIT_AMOUNT , OD.ENDORSEMENT_CREDIT_AMOUNT , OD.BANK_CHARGE_AMOUNT , OD.BANK_CHARGES_CREDIT_CCID , OD.BANK_CHARGES_DEBIT_CCID , OD.BANK_CHARGES_CREDIT_AMOUNT , OD.BANK_CHARGES_DEBIT_AMOUNT , OD.REQUEST_ID , OD.RETURN_INFO , OD.INTEREST_INDICATOR , OD.RETURN_REQUEST_ID , OD.GL_CANCEL_DATE , OD.ORG_ID , OD.ATTRIBUTE_CATEGORY , OD.ATTRIBUTE1 , OD.ATTRIBUTE2 , OD.ATTRIBUTE3 , OD.ATTRIBUTE4 , OD.ATTRIBUTE5 , OD.ATTRIBUTE6 , OD.ATTRIBUTE7 , OD.ATTRIBUTE8 , OD.ATTRIBUTE9 , OD.ATTRIBUTE10 , OD.ATTRIBUTE11 , OD.ATTRIBUTE12 , OD.ATTRIBUTE13 , OD.ATTRIBUTE14 , OD.ATTRIBUTE15, MC.LAST_UPDATE_DATE , MC.LAST_UPDATED_BY , MC.CREATION_DATE , MC.CREATED_BY , MC.LAST_UPDATE_LOGIN , OD.FACTORING_CHARGES_CREDIT_CCID, OD.FACTORING_CHARGES_DEBIT_CCID, OD.FACTORING_CHARGES_CRED_AMOUNT, OD.FACTORING_CHARGES_DEB_AMOUNT, OD.DISCOUNTED_BILLS_CREDIT_CCID, OD.DISCOUNTED_BILLS_DEBIT_CCID, OD.DISCOUNTED_BILLS_CRED_AMOUNT, OD.DISCOUNTED_BILLS_DEB_AMOUNT, OD.DISCOUNT_CREDIT_CCID, OD.DISCOUNT_DEBIT_CCID, OD.DISCOUNT_CRED_AMOUNT, OD.DISCOUNT_DEB_AMOUNT, OD.CASH_CREDIT_CCID, OD.CASH_DEBIT_CCID, OD.CASH_CRED_AMOUNT , OD.CASH_DEB_AMOUNT ,OD.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM JL_BR_AR_OCCURRENCE_DOCS OD , JL_BR_AR_MC_OCC_DOCS MC, HZ_PARTIES BANK, HZ_ORGANIZATION_PROFILES BANKPROFILE WHERE MC.OCCURRENCE_ID = OD.OCCURRENCE_ID AND BANK.PARTY_ID = OD.BANK_PARTY_ID AND BANK.PARTY_ID = BANKPROFILE.PARTY_ID AND trunc(SYSDATE) between TRUNC(BANKPROFILE. effective_start_date) and NVL(TRUNC(BANKPROFILE.effective_end_date), trunc(SYSDATE)+1) AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'), 45, 10)), -99)

SQL_Statement

SELECT MC.OCCURRENCE_ID , OD.DOCUMENT_ID , OD.BANK_OCCURRENCE_CODE , OD.BANK_PARTY_ID , BANKPROFILE.BANK_OR_BRANCH_NUMBER BANK_NUMBER, OD.BANK_OCCURRENCE_TYPE , OD.OCCURRENCE_DATE , OD.OCCURRENCE_STATUS , OD.ORIGINAL_REMITTANCE_MEDIA , OD.REMITTANCE_MEDIA , OD.SELECTION_DATE , OD.BORDERO_ID , OD.PORTFOLIO_CODE , OD.TRADE_NOTE_NUMBER , OD.DUE_DATE, OD.DOCUMENT_AMOUNT, OD.BANK_INSTRUCTION_CODE1 , OD.BANK_INSTRUCTION_CODE2 , OD.NUM_DAYS_INSTRUCTION , OD.INTEREST_PERCENT , OD.INTEREST_PERIOD , OD.INTEREST_AMOUNT , OD.GRACE_DAYS , OD.DISCOUNT_LIMIT_DATE , OD.DISCOUNT_AMOUNT , OD.CUSTOMER_ID , OD.SITE_USE_ID , OD.ABATEMENT_AMOUNT , MC.FLAG_POST_GL , OD.GL_DATE , MC.GL_POSTED_DATE , OD.ENDORSEMENT_CREDIT_CCID , OD.ENDORSEMENT_DEBIT_CCID , OD.ENDORSEMENT_DEBIT_AMOUNT , OD.ENDORSEMENT_CREDIT_AMOUNT , OD.BANK_CHARGE_AMOUNT , OD.BANK_CHARGES_CREDIT_CCID , OD.BANK_CHARGES_DEBIT_CCID , OD.BANK_CHARGES_CREDIT_AMOUNT , OD.BANK_CHARGES_DEBIT_AMOUNT , OD.REQUEST_ID , OD.RETURN_INFO , OD.INTEREST_INDICATOR , OD.RETURN_REQUEST_ID , OD.GL_CANCEL_DATE , OD.ORG_ID , OD.ATTRIBUTE_CATEGORY , OD.ATTRIBUTE1 , OD.ATTRIBUTE2 , OD.ATTRIBUTE3 , OD.ATTRIBUTE4 , OD.ATTRIBUTE5 , OD.ATTRIBUTE6 , OD.ATTRIBUTE7 , OD.ATTRIBUTE8 , OD.ATTRIBUTE9 , OD.ATTRIBUTE10 , OD.ATTRIBUTE11 , OD.ATTRIBUTE12 , OD.ATTRIBUTE13 , OD.ATTRIBUTE14 , OD.ATTRIBUTE15, MC.LAST_UPDATE_DATE , MC.LAST_UPDATED_BY , MC.CREATION_DATE , MC.CREATED_BY , MC.LAST_UPDATE_LOGIN , OD.FACTORING_CHARGES_CREDIT_CCID, OD.FACTORING_CHARGES_DEBIT_CCID, OD.FACTORING_CHARGES_CRED_AMOUNT, OD.FACTORING_CHARGES_DEB_AMOUNT, OD.DISCOUNTED_BILLS_CREDIT_CCID, OD.DISCOUNTED_BILLS_DEBIT_CCID, OD.DISCOUNTED_BILLS_CRED_AMOUNT, OD.DISCOUNTED_BILLS_DEB_AMOUNT, OD.DISCOUNT_CREDIT_CCID, OD.DISCOUNT_DEBIT_CCID, OD.DISCOUNT_CRED_AMOUNT, OD.DISCOUNT_DEB_AMOUNT, OD.CASH_CREDIT_CCID, OD.CASH_DEBIT_CCID, OD.CASH_CRED_AMOUNT , OD.CASH_DEB_AMOUNT ,OD.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM JL_BR_AR_OCCURRENCE_DOCS OD , JL_BR_AR_MC_OCC_DOCS MC, HZ_PARTIES BANK, HZ_ORGANIZATION_PROFILES BANKPROFILE WHERE MC.OCCURRENCE_ID = OD.OCCURRENCE_ID AND BANK.PARTY_ID = OD.BANK_PARTY_ID AND BANK.PARTY_ID = BANKPROFILE.PARTY_ID AND trunc(SYSDATE) between TRUNC(BANKPROFILE. effective_start_date) and NVL(TRUNC(BANKPROFILE.effective_end_date), trunc(SYSDATE)+1) AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'), 45, 10)), -99)