Query for Receipt Class and Receipt Method Form Data Extraction

SELECT 

ARC.NAME RECEIPT_CLASSES,

ARM.NAME ,

ARM.PRINTED_NAME,

ARM.START_DATE "EFFECTIVE DATES FROM",

HOA.NAME "OPERATING UNIT",

CEA.BANK_ACCOUNT_NAME,

CEA.BANK_ACCOUNT_NUM,

CEA.BANK_ACCOUNT_ID,

CEA.IBAN_NUMBER,

CEA.EFT_USER_NUM,

CBBV.BANK_NAME,

CBBV.BANK_BRANCH_NAME,

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.CASH_CCID)"CASH ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.ON_ACCOUNT_CCID)"ON ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.UNAPPLIED_CCID)"UNAPPLIED ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.UNEARNED_CCID) "UNEARNED ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.UNIDENTIFIED_CCID)"UNIDENTIFIED ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.FACTOR_CCID)"FACTORING",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.BANK_CHARGES_CCID) "BANK CHARGES ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.RECEIPT_CLEARING_CCID) "RECEIPT CLEARING ACCOUNT"

FROM

AR_RECEIPT_CLASSES ARC,

AR_RECEIPT_METHODS ARM,

AR_RECEIPT_METHOD_ACCOUNTS_ALL ARMAA,

HR_ORGANIZATION_UNITS HOA,

CE_BANK_ACCT_USES_ALL CBAUA,

CE_BANK_ACCOUNTS CEA,

CE_BANK_BRANCHES_V CBBV

WHERE

1 = 1

AND 

ARC.RECEIPT_CLASS_ID = ARM.RECEIPT_CLASS_ID

AND 

ARM.RECEIPT_METHOD_ID = ARMAA.RECEIPT_METHOD_ID

AND 

ARM.END_DATE IS NULL

AND 

ARMAA.ORG_ID = HOA.ORGANIZATION_ID

AND 

ARMAA.REMIT_BANK_ACCT_USE_ID = CBAUA.BANK_ACCT_USE_ID

AND 

CBAUA.BANK_ACCOUNT_ID = CEA.BANK_ACCOUNT_ID

AND 

CEA.BANK_BRANCH_ID = CBBV.BRANCH_PARTY_ID

ORDER BY RECEIPT_CLASSES;

#oracleebs #r12 #receivables #cashmanagement #br100 #query #sql #receiptclass #receiptmethod #bankaccounts