------------------------------------------------
Employee as a supplier Bank details
------------------------------------------------
SELECT aps.vendor_id,
apss.vendor_site_id,
aps.vendor_name,
apss.vendor_site_code,
ieb.bank_name,
ieb.country,
iebb.bank_branch_name,
iebb.eft_swift_code,
iebb.branch_number,
ieba.bank_account_num,
ieba.bank_account_name,
iban
FROM ap.ap_suppliers aps,
per_all_people_f papf,
ap.ap_supplier_sites_all apss,
apps.iby_ext_bank_accounts ieba,
apps.iby_account_owners iao,
apps.iby_ext_banks_v ieb,
apps.iby_ext_bank_branches_v iebb
WHERE aps.vendor_id = apss.vendor_id
AND iao.account_owner_party_id = aps.party_id
AND ieba.ext_bank_account_id = iao.ext_bank_account_id
AND ieb.bank_party_id = iebb.bank_party_id
AND ieba.branch_id = iebb.branch_party_id
AND ieba.bank_id = ieb.bank_party_id
AND aps.employee_id = papf.person_id
AND TRUNC(SYSDATE) BETWEEN papf.effective_start_date AND
papf.effective_end_date;
-----------------------------------------------------
Supplier Bank details (Not an Employee)
-----------------------------------------------------
SELECT aps.vendor_id,
apss.vendor_site_id,
aps.vendor_name,
apss.vendor_site_code,
ieb.bank_name,
ieb.country,
iebb.bank_branch_name,
iebb.eft_swift_code,
iebb.branch_number,
ieba.bank_account_num,
ieba.bank_account_name,
iban
FROM ap.ap_suppliers aps,
ap.ap_supplier_sites_all apss,
apps.iby_ext_bank_accounts ieba,
apps.iby_account_owners iao,
apps.iby_ext_banks_v ieb,
apps.iby_ext_bank_branches_v iebb
WHERE aps.vendor_id = apss.vendor_id
AND iao.account_owner_party_id = aps.party_id
AND ieba.ext_bank_account_id = iao.ext_bank_account_id
AND ieb.bank_party_id = iebb.bank_party_id
AND ieba.branch_id = iebb.branch_party_id
AND ieba.bank_id = ieb.bank_party_id
---Check series information exists in CE_PAYMENT_DOCUMENTS table.
How Lemeridian funding service grant me a loan!!!
ReplyDeleteHello everyone, I'm Lea Paige Matteo from Zurich Switzerland and want to use this medium to express gratitude to lemeridian funding service for fulfilling his promise by granting me a loan, I was stuck in a financial situation and needed to refinance and pay my bills as well as start up a Business. I tried seeking for loans from various loan firms both private and corporate organisations but never succeeded and most banks declined my credit request. But as God would have it, I was introduced by a friend named Lisa Rice to Le_meridian funding service and undergone the due process of obtaining a loan from the company, to my greatest surprise within 48hrs just like my friend Lisa, I was also granted a loan of $216,000.00 So my advise to everyone who desires a loan, "if you must contact any firm with reference to securing a loan online with low interest rate of 1.9% and better repayment plans/schedule, please contact Le_meridian funding service. Besides, he doesn't know that am doing this but due to the joy in me, I'm so happy and wish to let people know more about this great company whom truly give out loans, it is my prayer that GOD should bless them more as they put smiles on peoples faces. You can contact them via email on {lfdsloans@lemeridianfds.com Or lfdsloans@outlook.com} or Text through Whatsapp +1-989 394 3740.
Useful code
ReplyDeleteDEAR APPLICANT,
ReplyDeleteWe offer Affordable loan at 3% interest rate available for local and international borrowers. We are certified,trustworthy, reliable, efficient, Fast and dynamic and a co-operate financier for real estate and any kinds of business financing,we offer the following:* Personal Loans * Student Loan * Business Loans * Consolidation Loan * Combination Loan* *Home Enhancement* Car Loan *Construction Loan e.t.c
We are Christian organization founded, people in needs of assistance helps, such as financial help. So, if you go through financial difficulties or you are in any financial mess, and you need funds, to start you need your own business, or you need a loan to pay off your debts or pay your bills, start a nice business, or you will find it difficult, to obtain capital loan from local banks, for the Bible says , "" Anyone who asks, receives Luke 11.10, and who seeks, finds, and who knocks on the door, the door will be opened ", so do not miss this chance, because Jesus is the same yesterday, today, and forever more. Please this is for serious minded and God-fearing people.
Fill the application form below for further information.
Full Name:___________
Sex:________
Age:______
Country:__________
Address___________
State: ________
Tel:______
Occupation: __________
Monthly Income:___________
Loan Amount Needed ($) :__________
Amount in Words:
Loan Duration:__________
Pan Card or Voters Id No:__________
We await your responds
Regards
Trust Bridge Financial Service
E_mail: trustbridgefinancialservice943@yahoo.com