0 Replies Latest reply on Jan 23, 2015 10:42 AM by 2754157

    How do i get  Supplier Bank Information in Oracle DataWarehouse?




      I am having a requirement that i need to show bank transactions from one bank to another(external). This seems to me of supplier.

      I am having W_BANK_D table but i don't know where to join to get the required information. Currently i have joined to W_AP_XACT_F table with Bank_Wid but that seems to give me the internal (source) banks. So How Can i get the destination  (external--supplier) bank information?

      Thanks for your help in advance.