AP Bank Account Listing (1)

Description
Categories: Concurrent Program
Imported from Concurrent Program
Application: Payables
Source: Bank Account Listing
Short Name: APXBABAL
Run AP Bank Account Listing (1) and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT decode ( upper ( : P_ORDER_BY_PAR ) , 'BANK,BRANCH,ACCOUNT NAME' , 'NO SORT' , upper ( ba . bank_account_name ) ) C_BANK_SORT_ACCOUNT_NAME , upper ( bb . bank_name ) C_SORT_BANK_NAME , bb . bank_name C_BANK_NAME , upper ( bb . bank_branch_name ) C_SORT_BRANCH_NAME , bb . bank_branch_name C_BRANCH_NAME , upper ( ba . bank_account_name ) C_SORT_ACCOUNT_NAME , ba . bank_account_name C_ACCOUNT_NAME , bb . branch_party_id C_BRANCH_ID , ba . bank_account_id C_ACCOUNT_ID , ba . bank_account_num C_BANK_ACCOUNT_NUMBER , ba . description C_DESCRIPTION , ba . end_date C_INACTIVE_DATE , ba . currency_code C_CURRENCY_CODE , ba . max_check_amount C_MAX_CHECK_AMOUNT , ba . min_check_amount C_MIN_CHECK_AMOUNT , cpd . payment_document_name C_DOCUMENT_NAME , cpd . format_code C_DISBURSEMENT_CODE , la . displayed_field C_DISBURSEMENT_TYPE , cpd . number_of_setup_documents C_NUM_SETUP_CHECKS , cpd . last_issued_document_number C_LAST_DOCUMENT_USED , cpd . last_available_document_number C_LAST_AVAILABLE_DOC_NUM , cpd . inactive_date C_STOCK_INACTIVE_DATE ,  (GLCC.SEGMENT1||'\n'||GLCC.SEGMENT2||'\n'||GLCC.SEGMENT3||'\n'||GLCC.SEGMENT4||'\n'||GLCC.SEGMENT5||'\n'||GLCC.SEGMENT6||'\n'||GLCC.SEGMENT7||'\n'||GLCC.SEGMENT8||'\n'||GLCC.SEGMENT9||'\n'||GLCC.SEGMENT10||'\n'||GLCC.SEGMENT11||'\n'||GLCC.SEGMENT12||'\n'||GLCC.SEGMENT13||'\n'||GLCC.SEGMENT14||'\n'||GLCC.SEGMENT15||'\n'||GLCC.SEGMENT16||'\n'||GLCC.SEGMENT17||'\n'||GLCC.SEGMENT18||'\n'||GLCC.SEGMENT19||'\n'||GLCC.SEGMENT20||'\n'||GLCC.SEGMENT21||'\n'||GLCC.SEGMENT22||'\n'||GLCC.SEGMENT23||'\n'||GLCC.SEGMENT24||'\n'||GLCC.SEGMENT25||'\n'||GLCC.SEGMENT26||'\n'||GLCC.SEGMENT27||'\n'||GLCC.SEGMENT28||'\n'||GLCC.SEGMENT29||'\n'||GLCC.SEGMENT30) C_FLEXDATA ,  (GLCC2.SEGMENT1||'\n'||GLCC2.SEGMENT2||'\n'||GLCC2.SEGMENT3||'\n'||GLCC2.SEGMENT4||'\n'||GLCC2.SEGMENT5||'\n'||GLCC2.SEGMENT6||'\n'||GLCC2.SEGMENT7||'\n'||GLCC2.SEGMENT8||'\n'||GLCC2.SEGMENT9||'\n'||GLCC2.SEGMENT10||'\n'||GLCC2.SEGMENT11||'\n'||GLCC2.SEGMENT12||'\n'||GLCC2.SEGMENT13||'\n'||GLCC2.SEGMENT14||'\n'||GLCC2.SEGMENT15||'\n'||GLCC2.SEGMENT16||'\n'||GLCC2.SEGMENT17||'\n'||GLCC2.SEGMENT18||'\n'||GLCC2.SEGMENT19||'\n'||GLCC2.SEGMENT20||'\n'||GLCC2.SEGMENT21||'\n'||GLCC2.SEGMENT22||'\n'||GLCC2.SEGMENT23||'\n'||GLCC2.SEGMENT24||'\n'||GLCC2.SEGMENT25||'\n'||GLCC2.SEGMENT26||'\n'||GLCC2.SEGMENT27||'\n'||GLCC2.SEGMENT28||'\n'||GLCC2.SEGMENT29||'\n'||GLCC2.SEGMENT30) C_FLEXDATA2 FROM ce_bank_branches_v bb , ce_bank_accounts ba , ce_bank_acct_uses_all cbau , ce_gl_accounts_ccid cgac , gl_code_combinations glcc , gl_code_combinations glcc2 , ce_payment_documents cpd , ap_lookup_codes la , ap_system_parameters asp   WHERE ba.bank_branch_id = bb.branch_party_id AND cpd.internal_bank_account_id (+) = ba.bank_account_id AND ba.bank_account_id = cbau.bank_account_id AND cbau.bank_acct_use_id = cgac.bank_acct_use_id AND glcc.code_combination_id (+) = cgac.ap_asset_ccid AND glcc2.code_combination_id (+) = cgac.cash_clearing_ccid AND ( ( upper ( : P_BANK_ACCOUNT_PAR ) = 'BOTH' ) OR ( upper ( : P_BANK_ACCOUNT_PAR ) = 'INACTIVE' AND ( nvl ( ba.end_date , : P_EFFECTIVE_DATE + 1 ) <= : P_EFFECTIVE_DATE ) ) OR ( upper ( : P_BANK_ACCOUNT_PAR ) = 'ACTIVE' AND ( nvl ( ba.end_date , : P_EFFECTIVE_DATE + 1 ) >= : P_EFFECTIVE_DATE ) ) ) AND la.lookup_type (+) = 'DISBURSEMENT TYPE' AND la.lookup_code (+) = cpd.format_code AND ba.account_classification = 'INTERNAL' AND asp.org_id = cbau.org_id ORDER BY 1 ASC,2 ASC,4 ASC,8 ASC,6 ASC,7 ASC,9 ASC,11 ASC,10 ASC,23 ASC,24 ASC,13 ASC,14 ASC,12 ASC,15 ASC , DECODE ( UPPER ( : P_ORDER_BY_PAR ) , 'BANK,BRANCH,ACCOUNT NAME' , upper ( bb.bank_name ) , upper ( ba.bank_account_name ) ) , DECODE ( UPPER ( : P_ORDER_BY_PAR ) , 'BANK,BRANCH,ACCOUNT NAME' , upper ( bb.bank_branch_name ) , '' ) , DECODE ( UPPER ( : P_ORDER_BY_PAR ) , 'BANK,BRANCH,ACCOUNT NAME' , upper ( ba.bank_account_name ) , '' )
Parameter Name SQL text Validation
Sort Accounts By
 
LOV Oracle
Include Active/Inactive Accounts
 
LOV Oracle
Effective Date
 
Date
Blitz Report™