1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

bank accounts regarding

Discussion in 'Oracle Financials' started by rpriya263, Dec 15, 2012.

  1. rpriya263

    rpriya263 Guest

    hi.. this is priya can any one help me out....

    WHERE WE WILL FIND REMMITANCE BANK NAME IN R12 AND WHAT IS THE JOIN BETWEEN THIS BANK'S TABLE AND RECEIVABLES

    REGARDS,
    PRIYA...
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Have you found any solution for this ??
     
  3. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Priya,

    The following query gives you the bank names.

    Code (SQL):
    SELECT * FROM HZ_ORGANIZATION_PROFILES WHERE CREATED_BY_MODULE = 'CE';