Sunday, May 26, 2013
Query to fetch Trading partner Details of Bank Branch for EDI Payments
Below query is shared by our Guest Author jain.anurag1988@gmail.com , This query is used to verify whether the Trading partner setup exists for a BANK BRANCH.
SELECT DISTINCT cba.bank_account_name,
cvv.bank_branch_name,
bktph.tp_code
FROM ce_bank_accounts cba,
ce_bank_branches_v cvv,
hz_contact_points hcp,
ece_tp_headers bktph,
ece_tp_details bktpd
WHERE hcp.owner_table_id = cba.bank_branch_id
AND cvv.branch_party_id = cba.bank_branch_id
AND bktph.tp_header_id = hcp.edi_tp_header_id(+)
AND bktpd.tp_header_id = bktph.tp_header_id(+)
AND bktpd.document_id = 'PYO'
AND hcp.owner_table_name = 'HZ_PARTIES'
AND hcp.contact_point_type = 'EDI'
AND bktpd.edi_flag = 'Y';
Thank you Anurag
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
2 Responses to “Query to fetch Trading partner Details of Bank Branch for EDI Payments”
May 30, 2013 at 4:20 AM
Hey .. thanks man.. :) . will try to contribute more.. Anurag
September 28, 2022 at 2:42 PM
This wwas great to read
Post a Comment