check format in R12

[niletra]

HI
Anyone can provide me the sample query for CHECK FORMAT IN the R12

[ahmadbilal]

it's for WIRE tweak it as per your requirement.


SELECT distinct
aia.party_site_id,aia.party_id,aca.bank_account_name || ' AED Current ' bank_account_name, abaa.bank_account_id,
aca.amount chk_amt,'( ' || upc_amount_in_words (aca.amount)|| ' )' amount_in_word, aca.check_date,
aca.check_number, aca.currency_code, aipa.check_id,aipa.payment_num,
aipa.period_name, aipa.posted_flag, aipa.set_of_books_id,
aipa.bank_account_num, aipa.bank_account_type, aipa.bank_num,aipa.org_id, aca.vendor_name,
aca.vendor_site_code, aca.vendor_site_id,
ipa.EXT_BANK_ACCOUNT_NAME bANK_NAME,
ipa.EXT_BANK_ACCOUNT_NUMBER BEN_ACC_NO,
ipa.EXT_BANK_ACCOUNT_NUM_ELEC,
ipa.EXT_BANK_ACCOUNT_TYPE,
ipa.INT_BANK_NAME,ipa.INT_BANK_BRANCH_NAME,
ipa.EXT_BANK_NAME xbank,
cbbv.BANK_NAME bnk_branch,
cbbv.CITY||' - '||ftv.TERRITORY_SHORT_NAME cty_cntry,
cbbv.ADDRESS_LINE1 || ',' ||cbbv.ADDRESS_LINE2 || ',' ||cbbv.ADDRESS_LINE3 || ','||cbbv.ADDRESS_LINE4 full_address,
ipa.PAYEE_ADDRESS_CONCAT,ieba.IBAN,cbbv.EFT_USER_NUMBER SWIFT,cbbv.EFT_SWIFT_CODE BIC,AIA.EXTERNAL_BANK_ACCOUNT_ID,IEBA.BANK_ACCOUNT_NUM XX,
CBBV.EFT_SWIFT_CODE
FROM ap_bank_accounts_all abaa,
ap_checks_all aca,
ap_invoice_payments_all aipa,
ap_invoices_all aia,
IBY_PAYMENTS_ALL ipa,
ce_bank_branches_V cbbv,
iby_ext_bank_accounts ieba,
fnd_territories_vl ftv
WHERE abaa.bank_account_id(+) = aca.bank_account_id
AND aca.check_id = aipa.check_id
and cbbv.PK_ID = ipa.INT_BANK_BRANCH_PARTY_ID
and ipa.payment_id = aca.PAYMENT_ID
and ieba.EXT_BANK_ACCOUNT_ID(+) = ipa.external_bank_account_id
and cbbv.BANK_HOME_COUNTRY = ftv.TERRITORY_CODE
-- AND aca.payment_id = :paymnet_id
-- AND AIPA.payment_NUM = :paymnet_NUM
AND aca.check_number = NVL(:PAY,aca.check_number)
AND aia.invoice_id = aipa.invoice_id
and upper(aca.PAYMENT_METHOD_CODE) = 'WIRE'
and aca.STATUS_LOOKUP_CODE <> 'VOIDED'

For Payee Bank details see my blog

[niletra]

THANKS A LOT...........AHMAD

[niletra]

hi ahmed
CAN U U PLZ TELL ME FOR RUN THE PAYMENT Manager then MY FORMAT IS MANDOTORY TO BUILT ON XML PUBLISHER OR
IT CAN RUN WITH THE.RDF FORMAT ALSO.

I WILL SEND YOU QUERY I AM NOT ABLE TO RUN FOR THE PAYMENT REQUEST...........CAN U PLZ GUIDE ME?