JL_BR_AR_REC_MET_ACCTS_EXT

Details

Schema: FUSION
Object owner: JL
Object type: VIEW

Columns

Name
ROW_ID BANK_ACCT_USE_ID RECEIPT_METHOD_ID BANK_CHARGES_CCID COLL_ENDORSEMENT_CCID BILLS_COLLECTION_CCID OTHER_CREDITS_CCID FACTORING_DOCS_CCID PORTFOLIO_CODE MIN_DOCUMENT_AMOUNT MAX_DOCUMENT_AMOUNT MIN_REMITTANCE_AMOUNT MAX_REMITTANCE_AMOUNT BANK_INSTRUCTION_CODE1 BANK_INSTRUCTION_CODE2 BANK_CHARGE_AMOUNT FACTORING_RATE FACTORING_RATE_PERIOD BATCH_SOURCE_ID CALCULATED_INTEREST_CCID INTEREST_WRITEOFF_CCID FACTORING_INTEREST_CCID ABATEMENT_WRITEOFF_CCID ABATEMENT_REVENUE_CCID INTEREST_REVENUE_CCID CALCULATED_INTEREST_RECTRX_ID INTEREST_WRITEOFF_RECTRX_ID INTEREST_REVENUE_RECTRX_ID ABATEMENT_WRITEOFF_RECTRX_ID ABATEMENT_REVENUE_RECTRX_ID WRITEOFF_PERC_TOLERANCE WRITEOFF_AMOUNT_TOLERANCE GL_DATE_BANK_RETURN DISC_ENDORSEMENT_CCID DISCOUNTED_BILLS_CCID BILLS_DISCOUNT_CCID FACTORING_CHARGES_CCID GL_DATE_BANK_RETURN_DSP FLOATING ORG_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN RECEIPT_METHOD_NAME_DSP RECEIPT_CLASS_NAME_DSP COLLECTION_METHOD COLLECTION_METHOD_DSP BANK_PARTY_ID BANK_NAME_DSP BANK_NUMBER_DSP BANK_BRANCH_NAME_DSP BANK_NUM_DSP BANK_BRANCH_ID_DSP BANK_ACCOUNT_NUM_DSP CALC_INTEREST_RECTRX_ID_DSP INT_WRITEOFF_RECTRX_ID_DSP INT_REVENUE_RECTRX_ID_DSP ABATE_WRITEOFF_RECTRX_ID_DSP ABATE_REVENUE_RECTRX_ID_DSP BANK_INSTRUCTION_TYPE1 BANK_INSTRUCTION_CODE1_DSP BANK_INSTRUCTION_TYPE2 BANK_INSTRUCTION_CODE2_DSP BATCH_SOURCE_DSP MAX_COLLECTION_DOCS OCC_FILE_FORMAT_PGM_ID OCC_REP_FORMAT_PGM_ID FACTOR_FORMAT_PGM_ID FACTOR_REMITTANCE_MEDIA COLL_FORMAT_PGM_ID COLL_REMITTANCE_MEDIA OBJECT_VERSION_NUMBER REC_MET_ACCTS_EXT_ID PRINT_COLL_DOC_FOR_CUST_FLAG COLL_DOC_CUST_PRINT_PGM_ID BANK_SERVICE_CODE

Name

ROW_ID

BANK_ACCT_USE_ID

RECEIPT_METHOD_ID

BANK_CHARGES_CCID

COLL_ENDORSEMENT_CCID

BILLS_COLLECTION_CCID

OTHER_CREDITS_CCID

FACTORING_DOCS_CCID

PORTFOLIO_CODE

MIN_DOCUMENT_AMOUNT

MAX_DOCUMENT_AMOUNT

MIN_REMITTANCE_AMOUNT

MAX_REMITTANCE_AMOUNT

BANK_INSTRUCTION_CODE1

BANK_INSTRUCTION_CODE2

BANK_CHARGE_AMOUNT

FACTORING_RATE

FACTORING_RATE_PERIOD

BATCH_SOURCE_ID

CALCULATED_INTEREST_CCID

INTEREST_WRITEOFF_CCID

FACTORING_INTEREST_CCID

ABATEMENT_WRITEOFF_CCID

ABATEMENT_REVENUE_CCID

INTEREST_REVENUE_CCID

CALCULATED_INTEREST_RECTRX_ID

INTEREST_WRITEOFF_RECTRX_ID

INTEREST_REVENUE_RECTRX_ID

ABATEMENT_WRITEOFF_RECTRX_ID

ABATEMENT_REVENUE_RECTRX_ID

WRITEOFF_PERC_TOLERANCE

WRITEOFF_AMOUNT_TOLERANCE

GL_DATE_BANK_RETURN

DISC_ENDORSEMENT_CCID

DISCOUNTED_BILLS_CCID

BILLS_DISCOUNT_CCID

FACTORING_CHARGES_CCID

GL_DATE_BANK_RETURN_DSP

FLOATING

ORG_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

RECEIPT_METHOD_NAME_DSP

RECEIPT_CLASS_NAME_DSP

COLLECTION_METHOD

COLLECTION_METHOD_DSP

BANK_PARTY_ID

BANK_NAME_DSP

BANK_NUMBER_DSP

BANK_BRANCH_NAME_DSP

BANK_NUM_DSP

BANK_BRANCH_ID_DSP

BANK_ACCOUNT_NUM_DSP

CALC_INTEREST_RECTRX_ID_DSP

INT_WRITEOFF_RECTRX_ID_DSP

INT_REVENUE_RECTRX_ID_DSP

ABATE_WRITEOFF_RECTRX_ID_DSP

ABATE_REVENUE_RECTRX_ID_DSP

BANK_INSTRUCTION_TYPE1

BANK_INSTRUCTION_CODE1_DSP

BANK_INSTRUCTION_TYPE2

BANK_INSTRUCTION_CODE2_DSP

BATCH_SOURCE_DSP

MAX_COLLECTION_DOCS

OCC_FILE_FORMAT_PGM_ID

OCC_REP_FORMAT_PGM_ID

FACTOR_FORMAT_PGM_ID

FACTOR_REMITTANCE_MEDIA

COLL_FORMAT_PGM_ID

COLL_REMITTANCE_MEDIA

OBJECT_VERSION_NUMBER

REC_MET_ACCTS_EXT_ID

PRINT_COLL_DOC_FOR_CUST_FLAG

COLL_DOC_CUST_PRINT_PGM_ID

BANK_SERVICE_CODE

Query

SQL_Statement
SELECT RMAE.ROWID ROW_ID , RMAE.BANK_ACCT_USE_ID BANK_ACCT_USE_ID, RMAE.RECEIPT_METHOD_ID RECEIPT_METHOD_ID , RMAE.BANK_CHARGES_CCID BANK_CHARGES_CCID, RMAE.COLL_ENDORSEMENT_CCID COLL_ENDORSEMENT_CCID , RMAE.BILLS_COLLECTION_CCID BILLS_COLLECTION_CCID , RMAE.OTHER_CREDITS_CCID OTHER_CREDITS_CCID , RMAE.FACTORING_DOCS_CCID FACTORING_DOCS_CCID , RMAE.PORTFOLIO_CODE PORTFOLIO_CODE , RMAE.MIN_DOCUMENT_AMOUNT MIN_DOCUMENT_AMOUNT , RMAE.MAX_DOCUMENT_AMOUNT MAX_DOCUMENT_AMOUNT , RMAE.MIN_REMITTANCE_AMOUNT MIN_REMITTANCE_AMOUNT , RMAE.MAX_REMITTANCE_AMOUNT MAX_REMITTANCE_AMOUNT , RMAE.BANK_INSTRUCTION_CODE1 BANK_INSTRUCTION_CODE1 , RMAE.BANK_INSTRUCTION_CODE2 BANK_INSTRUCTION_CODE2 , RMAE.BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT , RMAE.FACTORING_RATE FACTORING_RATE , RMAE.FACTORING_RATE_PERIOD FACTORING_RATE_PERIOD , RMAE.BATCH_SOURCE_ID BATCH_SOURCE_ID , RMAE.CALCULATED_INTEREST_CCID CALCULATED_INTEREST_CCID , RMAE.INTEREST_WRITEOFF_CCID INTEREST_WRITEOFF_CCID , RMAE.FACTORING_INTEREST_CCID FACTORING_INTEREST_CCID , RMAE.ABATEMENT_WRITEOFF_CCID ABATEMENT_WRITEOFF_CCID , RMAE.ABATEMENT_REVENUE_CCID ABATEMENT_REVENUE_CCID , RMAE.INTEREST_REVENUE_CCID INTEREST_REVENUE_CCID , RMAE.CALCULATED_INTEREST_RECTRX_ID CALCULATED_INTEREST_RECTRX_ID , RMAE.INTEREST_WRITEOFF_RECTRX_ID INTEREST_WRITEOFF_RECTRX_ID , RMAE.INTEREST_REVENUE_RECTRX_ID INTEREST_REVENUE_RECTRX_ID , RMAE.ABATEMENT_WRITEOFF_RECTRX_ID ABATEMENT_WRITEOFF_RECTRX_ID , RMAE.ABATEMENT_REVENUE_RECTRX_ID ABATEMENT_REVENUE_RECTRX_ID , RMAE.WRITEOFF_PERC_TOLERANCE WRITEOFF_PERC_TOLERANCE , RMAE.WRITEOFF_AMOUNT_TOLERANCE WRITEOFF_AMOUNT_TOLERANCE , RMAE.GL_DATE_BANK_RETURN GL_DATE_BANK_RETURN , RMAE.DISC_ENDORSEMENT_CCID, RMAE.DISCOUNTED_BILLS_CCID, RMAE.BILLS_DISCOUNT_CCID, RMAE.FACTORING_CHARGES_CCID, FLV2.MEANING GL_DATE_BANK_RETURN_DSP , RMAE.FLOATING FLOATING , RMAE.ORG_ID ORG_ID , RMAE.LAST_UPDATE_DATE LAST_UPDATE_DATE , RMAE.LAST_UPDATED_BY LAST_UPDATED_BY , RMAE.CREATION_DATE CREATION_DATE , RMAE.CREATED_BY CREATED_BY , RMAE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , ARM.NAME RECEIPT_METHOD_NAME_DSP , ARC.NAME RECEIPT_CLASS_NAME_DSP , ARC.GLOBAL_ATTRIBUTE1 COLLECTION_METHOD , FLV.MEANING COLLECTION_METHOD_DSP , HzPartyBank.PARTY_ID BANK_PARTY_ID, HzPartyBank.PARTY_NAME BANK_NAME_DSP , HzOrgProfileBank.BANK_OR_BRANCH_NUMBER BANK_NUMBER_DSP , HzPartyBranch.PARTY_NAME BANK_BRANCH_NAME_DSP , HzOrgProfileBranch.BANK_OR_BRANCH_NUMBER BANK_NUM_DSP , CeBankAccount.BANK_BRANCH_ID BANK_BRANCH_ID_DSP , CeBankAccount.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM_DSP , ART1.NAME CALC_INTEREST_RECTRX_ID_DSP , ART2.NAME INT_WRITEOFF_RECTRX_ID_DSP , ART3.NAME INT_REVENUE_RECTRX_ID_DSP , ART4.NAME ABATE_WRITEOFF_RECTRX_ID_DSP , ART5.NAME ABATE_REVENUE_RECTRX_ID_DSP , JABI.BANK_INSTRUCTION_TYPE BANK_INSTRUCTION_TYPE1 , JABI.DESCRIPTION BANK_INSTRUCTION_CODE1_DSP , JABI2.BANK_INSTRUCTION_TYPE BANK_INSTRUCTION_TYPE2 , JABI2.DESCRIPTION BANK_INSTRUCTION_CODE2_DSP , ABS.NAME BATCH_SOURCE_DSP , RMAE.max_collection_docs, RMAE.occ_file_format_pgm_id, RMAE.occ_rep_format_pgm_id, RMAE.factor_format_pgm_id, RMAE.factor_remittance_media, RMAE.coll_format_pgm_id, RMAE.coll_remittance_media ,RMAE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, RMAE.REC_MET_ACCTS_EXT_ID REC_MET_ACCTS_EXT_ID, RMAE.PRINT_COLL_DOC_FOR_CUST_FLAG PRINT_COLL_DOC_FOR_CUST_FLAG, RMAE.COLL_DOC_CUST_PRINT_PGM_ID COLL_DOC_CUST_PRINT_PGM_ID, RMAE.BANK_SERVICE_CODE BANK_SERVICE_CODE FROM JL_BR_AR_REC_MET_ACCTS_EXT_all RMAE, AR_RECEIPT_METHODS ARM, AR_RECEIPT_CLASSES ARC, FND_LOOKUPS FLV, FND_LOOKUPS FLV2, AR_RECEIVABLES_TRX_ALL ART1, AR_RECEIVABLES_TRX_ALL ART2, AR_RECEIVABLES_TRX_ALL ART3, AR_RECEIVABLES_TRX_ALL ART4, AR_RECEIVABLES_TRX_ALL ART5, JL_BR_AR_BANK_INSTRUCTIONS JABI, JL_BR_AR_BANK_INSTRUCTIONS JABI2, AR_BATCH_SOURCES ABS, CE_BANK_ACCOUNTS CeBankAccount, CE_BANK_ACCT_USES_ALL AcctUse, HZ_PARTIES HzPartyBank, HZ_ORGANIZATION_PROFILES HzOrgProfileBank, HZ_ORGANIZATION_PROFILES HzOrgProfileBranch, HZ_PARTIES HzPartyBranch WHERE ARM.RECEIPT_METHOD_ID = RMAE.RECEIPT_METHOD_ID AND ARM.RECEIPT_CLASS_ID = ARC.RECEIPT_CLASS_ID AND FLV.LOOKUP_CODE (+)= ARC.GLOBAL_ATTRIBUTE1 AND FLV.LOOKUP_TYPE (+) = 'JLBR_AR_COLLECTION_METHOD' AND FLV.ENABLED_FLAG (+) = 'Y' AND NVL(FLV.START_DATE_ACTIVE,trunc(SYSDATE)) <= trunc(SYSDATE) AND NVL(FLV.END_DATE_ACTIVE,trunc(SYSDATE)) >= trunc(SYSDATE) AND FLV2.LOOKUP_CODE (+) = RMAE.GL_DATE_BANK_RETURN AND FLV2.LOOKUP_TYPE (+) = 'JLBR_AR_GL_DATE_BANK_RETURN' AND FLV2.ENABLED_FLAG (+) = 'Y' AND NVL(FLV2.START_DATE_ACTIVE,SYSDATE) <= trunc(SYSDATE) AND NVL(FLV2.END_DATE_ACTIVE,trunc(SYSDATE)) >= trunc(SYSDATE) AND AcctUse.BANK_ACCT_USE_ID = RMAE.BANK_ACCT_USE_ID AND AcctUse.BANK_ACCOUNT_ID = CeBankAccount.BANK_ACCOUNT_ID AND JABI.BANK_INSTRUCTION_CODE (+) = RMAE.BANK_INSTRUCTION_CODE1 AND (JABI.BANK_PARTY_ID IS NULL OR (HzPartyBank.PARTY_ID = JABI.BANK_PARTY_ID))AND JABI2.BANK_INSTRUCTION_CODE (+) = RMAE.BANK_INSTRUCTION_CODE2 AND (JABI2.BANK_PARTY_ID IS NULL OR (HzPartyBank.PARTY_ID = JABI2.BANK_PARTY_ID)) AND ART1.RECEIVABLES_TRX_ID (+) = RMAE.CALCULATED_INTEREST_RECTRX_ID AND ART2.RECEIVABLES_TRX_ID (+) = RMAE.INTEREST_WRITEOFF_RECTRX_ID AND ART3.RECEIVABLES_TRX_ID (+) = RMAE.INTEREST_REVENUE_RECTRX_ID AND ART4.RECEIVABLES_TRX_ID (+) =RMAE.ABATEMENT_WRITEOFF_RECTRX_ID AND ART5.RECEIVABLES_TRX_ID (+) = RMAE.ABATEMENT_REVENUE_RECTRX_ID AND ABS.BATCH_SOURCE_ID (+) = RMAE.BATCH_SOURCE_ID and CeBankAccount.BANK_BRANCH_ID =HzPartyBranch.PARTY_ID AND HzPartyBranch.PARTY_TYPE = 'ORGANIZATION' and HzOrgProfileBranch.PARTY_ID = HzPartyBranch.PARTY_ID and trunc(SYSDATE) between TRUNC(HzOrgProfileBranch. effective_start_date) and NVL(TRUNC(HzOrgProfileBranch.effective_end_date), trunc(SYSDATE)+1) and CeBankAccount.BANK_ID =HzPartyBank.PARTY_ID AND HzPartyBank.PARTY_TYPE = 'ORGANIZATION' and HzPartyBank.status = 'A' and HzOrgProfileBank.PARTY_ID = HzPartyBank.PARTY_ID and trunc(SYSDATE) between TRUNC(HzOrgProfileBank.effective_start_date) and NVL(TRUNC(HzOrgProfileBank.effective_end_date), trunc(SYSDATE)+1)

SQL_Statement

SELECT RMAE.ROWID ROW_ID , RMAE.BANK_ACCT_USE_ID BANK_ACCT_USE_ID, RMAE.RECEIPT_METHOD_ID RECEIPT_METHOD_ID , RMAE.BANK_CHARGES_CCID BANK_CHARGES_CCID, RMAE.COLL_ENDORSEMENT_CCID COLL_ENDORSEMENT_CCID , RMAE.BILLS_COLLECTION_CCID BILLS_COLLECTION_CCID , RMAE.OTHER_CREDITS_CCID OTHER_CREDITS_CCID , RMAE.FACTORING_DOCS_CCID FACTORING_DOCS_CCID , RMAE.PORTFOLIO_CODE PORTFOLIO_CODE , RMAE.MIN_DOCUMENT_AMOUNT MIN_DOCUMENT_AMOUNT , RMAE.MAX_DOCUMENT_AMOUNT MAX_DOCUMENT_AMOUNT , RMAE.MIN_REMITTANCE_AMOUNT MIN_REMITTANCE_AMOUNT , RMAE.MAX_REMITTANCE_AMOUNT MAX_REMITTANCE_AMOUNT , RMAE.BANK_INSTRUCTION_CODE1 BANK_INSTRUCTION_CODE1 , RMAE.BANK_INSTRUCTION_CODE2 BANK_INSTRUCTION_CODE2 , RMAE.BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT , RMAE.FACTORING_RATE FACTORING_RATE , RMAE.FACTORING_RATE_PERIOD FACTORING_RATE_PERIOD , RMAE.BATCH_SOURCE_ID BATCH_SOURCE_ID , RMAE.CALCULATED_INTEREST_CCID CALCULATED_INTEREST_CCID , RMAE.INTEREST_WRITEOFF_CCID INTEREST_WRITEOFF_CCID , RMAE.FACTORING_INTEREST_CCID FACTORING_INTEREST_CCID , RMAE.ABATEMENT_WRITEOFF_CCID ABATEMENT_WRITEOFF_CCID , RMAE.ABATEMENT_REVENUE_CCID ABATEMENT_REVENUE_CCID , RMAE.INTEREST_REVENUE_CCID INTEREST_REVENUE_CCID , RMAE.CALCULATED_INTEREST_RECTRX_ID CALCULATED_INTEREST_RECTRX_ID , RMAE.INTEREST_WRITEOFF_RECTRX_ID INTEREST_WRITEOFF_RECTRX_ID , RMAE.INTEREST_REVENUE_RECTRX_ID INTEREST_REVENUE_RECTRX_ID , RMAE.ABATEMENT_WRITEOFF_RECTRX_ID ABATEMENT_WRITEOFF_RECTRX_ID , RMAE.ABATEMENT_REVENUE_RECTRX_ID ABATEMENT_REVENUE_RECTRX_ID , RMAE.WRITEOFF_PERC_TOLERANCE WRITEOFF_PERC_TOLERANCE , RMAE.WRITEOFF_AMOUNT_TOLERANCE WRITEOFF_AMOUNT_TOLERANCE , RMAE.GL_DATE_BANK_RETURN GL_DATE_BANK_RETURN , RMAE.DISC_ENDORSEMENT_CCID, RMAE.DISCOUNTED_BILLS_CCID, RMAE.BILLS_DISCOUNT_CCID, RMAE.FACTORING_CHARGES_CCID, FLV2.MEANING GL_DATE_BANK_RETURN_DSP , RMAE.FLOATING FLOATING , RMAE.ORG_ID ORG_ID , RMAE.LAST_UPDATE_DATE LAST_UPDATE_DATE , RMAE.LAST_UPDATED_BY LAST_UPDATED_BY , RMAE.CREATION_DATE CREATION_DATE , RMAE.CREATED_BY CREATED_BY , RMAE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , ARM.NAME RECEIPT_METHOD_NAME_DSP , ARC.NAME RECEIPT_CLASS_NAME_DSP , ARC.GLOBAL_ATTRIBUTE1 COLLECTION_METHOD , FLV.MEANING COLLECTION_METHOD_DSP , HzPartyBank.PARTY_ID BANK_PARTY_ID, HzPartyBank.PARTY_NAME BANK_NAME_DSP , HzOrgProfileBank.BANK_OR_BRANCH_NUMBER BANK_NUMBER_DSP , HzPartyBranch.PARTY_NAME BANK_BRANCH_NAME_DSP , HzOrgProfileBranch.BANK_OR_BRANCH_NUMBER BANK_NUM_DSP , CeBankAccount.BANK_BRANCH_ID BANK_BRANCH_ID_DSP , CeBankAccount.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM_DSP , ART1.NAME CALC_INTEREST_RECTRX_ID_DSP , ART2.NAME INT_WRITEOFF_RECTRX_ID_DSP , ART3.NAME INT_REVENUE_RECTRX_ID_DSP , ART4.NAME ABATE_WRITEOFF_RECTRX_ID_DSP , ART5.NAME ABATE_REVENUE_RECTRX_ID_DSP , JABI.BANK_INSTRUCTION_TYPE BANK_INSTRUCTION_TYPE1 , JABI.DESCRIPTION BANK_INSTRUCTION_CODE1_DSP , JABI2.BANK_INSTRUCTION_TYPE BANK_INSTRUCTION_TYPE2 , JABI2.DESCRIPTION BANK_INSTRUCTION_CODE2_DSP , ABS.NAME BATCH_SOURCE_DSP , RMAE.max_collection_docs, RMAE.occ_file_format_pgm_id, RMAE.occ_rep_format_pgm_id, RMAE.factor_format_pgm_id, RMAE.factor_remittance_media, RMAE.coll_format_pgm_id, RMAE.coll_remittance_media

,RMAE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

RMAE.REC_MET_ACCTS_EXT_ID REC_MET_ACCTS_EXT_ID,

RMAE.PRINT_COLL_DOC_FOR_CUST_FLAG PRINT_COLL_DOC_FOR_CUST_FLAG,

RMAE.COLL_DOC_CUST_PRINT_PGM_ID COLL_DOC_CUST_PRINT_PGM_ID,

RMAE.BANK_SERVICE_CODE BANK_SERVICE_CODE

FROM JL_BR_AR_REC_MET_ACCTS_EXT_all RMAE, AR_RECEIPT_METHODS ARM, AR_RECEIPT_CLASSES ARC, FND_LOOKUPS FLV, FND_LOOKUPS FLV2, AR_RECEIVABLES_TRX_ALL ART1, AR_RECEIVABLES_TRX_ALL ART2, AR_RECEIVABLES_TRX_ALL ART3, AR_RECEIVABLES_TRX_ALL ART4, AR_RECEIVABLES_TRX_ALL ART5, JL_BR_AR_BANK_INSTRUCTIONS JABI, JL_BR_AR_BANK_INSTRUCTIONS JABI2, AR_BATCH_SOURCES ABS, CE_BANK_ACCOUNTS CeBankAccount, CE_BANK_ACCT_USES_ALL AcctUse, HZ_PARTIES HzPartyBank, HZ_ORGANIZATION_PROFILES HzOrgProfileBank, HZ_ORGANIZATION_PROFILES HzOrgProfileBranch, HZ_PARTIES HzPartyBranch

WHERE ARM.RECEIPT_METHOD_ID = RMAE.RECEIPT_METHOD_ID AND ARM.RECEIPT_CLASS_ID = ARC.RECEIPT_CLASS_ID AND FLV.LOOKUP_CODE (+)= ARC.GLOBAL_ATTRIBUTE1 AND FLV.LOOKUP_TYPE (+) = 'JLBR_AR_COLLECTION_METHOD' AND FLV.ENABLED_FLAG (+) = 'Y' AND NVL(FLV.START_DATE_ACTIVE,trunc(SYSDATE)) <= trunc(SYSDATE) AND NVL(FLV.END_DATE_ACTIVE,trunc(SYSDATE)) >= trunc(SYSDATE) AND FLV2.LOOKUP_CODE (+) = RMAE.GL_DATE_BANK_RETURN AND FLV2.LOOKUP_TYPE (+) = 'JLBR_AR_GL_DATE_BANK_RETURN' AND FLV2.ENABLED_FLAG (+) = 'Y' AND NVL(FLV2.START_DATE_ACTIVE,SYSDATE) <= trunc(SYSDATE) AND NVL(FLV2.END_DATE_ACTIVE,trunc(SYSDATE)) >= trunc(SYSDATE) AND AcctUse.BANK_ACCT_USE_ID = RMAE.BANK_ACCT_USE_ID AND AcctUse.BANK_ACCOUNT_ID = CeBankAccount.BANK_ACCOUNT_ID AND JABI.BANK_INSTRUCTION_CODE (+) = RMAE.BANK_INSTRUCTION_CODE1 AND (JABI.BANK_PARTY_ID IS NULL OR (HzPartyBank.PARTY_ID = JABI.BANK_PARTY_ID))AND JABI2.BANK_INSTRUCTION_CODE (+) = RMAE.BANK_INSTRUCTION_CODE2 AND (JABI2.BANK_PARTY_ID IS NULL OR (HzPartyBank.PARTY_ID = JABI2.BANK_PARTY_ID)) AND ART1.RECEIVABLES_TRX_ID (+) = RMAE.CALCULATED_INTEREST_RECTRX_ID AND ART2.RECEIVABLES_TRX_ID (+) = RMAE.INTEREST_WRITEOFF_RECTRX_ID AND ART3.RECEIVABLES_TRX_ID (+) = RMAE.INTEREST_REVENUE_RECTRX_ID AND ART4.RECEIVABLES_TRX_ID (+) =RMAE.ABATEMENT_WRITEOFF_RECTRX_ID AND ART5.RECEIVABLES_TRX_ID (+) = RMAE.ABATEMENT_REVENUE_RECTRX_ID AND ABS.BATCH_SOURCE_ID (+) = RMAE.BATCH_SOURCE_ID and CeBankAccount.BANK_BRANCH_ID =HzPartyBranch.PARTY_ID AND HzPartyBranch.PARTY_TYPE = 'ORGANIZATION' and HzOrgProfileBranch.PARTY_ID = HzPartyBranch.PARTY_ID and trunc(SYSDATE) between TRUNC(HzOrgProfileBranch. effective_start_date) and NVL(TRUNC(HzOrgProfileBranch.effective_end_date), trunc(SYSDATE)+1) and CeBankAccount.BANK_ID =HzPartyBank.PARTY_ID AND HzPartyBank.PARTY_TYPE = 'ORGANIZATION' and HzPartyBank.status = 'A' and HzOrgProfileBank.PARTY_ID = HzPartyBank.PARTY_ID and trunc(SYSDATE) between TRUNC(HzOrgProfileBank.effective_start_date) and NVL(TRUNC(HzOrgProfileBank.effective_end_date), trunc(SYSDATE)+1)