How to find supplier bank detail In Oracle

See Below Table to Understand


Select *From Apps.Hz_Parties  

Select * From apps.Po_Vendors

Select * From apps.iby_account_owners;

Select * From apps.ap_supplier_sites_all;

select *from  apps.iby_ext_bank_accounts eba;

Select * From apps.iby_account_owners ao;

Select * From apps.iby_ext_banks_v eb;

Select * From apps.iby_ext_bank_branches_v ebb;

Select * From apps.hr_operating_units ;

How to find supplier bank detail In Oracle


Select pv.Vendor_Id
,      PV.LAST_UPDATE_DATE
,      Pv.Last_Updated_By
,      Pv.Vendor_Name
,      Pv.Summary_Flag
,      Pv.Party_Number
,      Pv.Pay_Awt_Group_Id
,      Assa.Vendor_Site_Code          
,      Eb.Bank_Name                 
,      Ebb.Bank_Branch_Name     
,      Ebb.Branch_Number            
,      Eba.Bank_Account_Num         
,      eba.bank_account_name

From Apps.Po_Vendors Pv, 
  apps.ap_supplier_sites_all assa ,
  apps.iby_ext_bank_accounts eba  ,
  apps.iby_account_owners ao      ,
  apps.iby_ext_banks_v eb         ,
  Apps.Iby_Ext_Bank_Branches_V Ebb
  --Apps.Hr_Operating_Units Hou
Where pv.Vendor_Type_Lookup_Code='EMPLOYEE' 
And Pv.Vendor_Id           = Assa.Vendor_Id
AND ao.account_owner_party_id = pv.party_id
AND eba.ext_bank_account_id   = ao.ext_bank_account_id
AND eb.bank_party_id          = ebb.bank_party_id
And Eba.Branch_Id             = Ebb.Branch_Party_Id
And Eba.Bank_Id               = Eb.Bank_Party_Id
And Pv.Employee_Id=3994;

Leave a Reply

Your email address will not be published. Required fields are marked *