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!

unable to see bank detailes from frontend

Discussion in 'Oracle Apps Technical' started by Tejaswil, Nov 29, 2013.

  1. Tejaswil

    Tejaswil Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    I did supplier bank conversion where I created bank,bank branch and account for the given supplier.
    But when I try to check details from frontend the bank detailes to the supplier was not assigned.
    Please suggest how can this assignment of bank to supplier can be done from backend.
     
  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    Where you have attached? means supplier or supplier site or Address Level ?


    If you attached at supplier site level select that site in " Select Account Assignment Level " field then query....

    Regards
    Sambasiva Reddy.K
     
  3. Tejaswil

    Tejaswil Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Yes, I assigned at ss(supplier site) level. and i am quering in the same way... but i am not finding that created account details over there.
     
  4. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    Check with below query whether the bank details are displaying or not.

    Code (SQL):
     SELECT   hou.name  operating_unit
                   , aps.vendor_name supplier_name            
                   , aps.segment1 supplier_number
                   , assa.vendor_site_code supplier_site  
                   , assa.vendor_site_code_alt medics_id
                   , decode(assa.inactive_date,NULL,'Active','In Active') site_status
                   , ( SELECT flv.meaning FROM fnd_lookup_values flv WHERE flv.lookup_code =assa.pay_on_code AND lookup_type = 'PAY ON CODE' AND rownum = 1) pay_on_rept              
                   , ( SELECT flv.meaning FROM fnd_lookup_values flv WHERE flv.lookup_code = assa.pay_on_receipt_summary_code  AND lookup_type = 'ERS INVOICE_SUMMARY' AND rownum = 1) invoice_summary_level
                   , decode(assa.create_debit_memo_flag,'N','No','Y','Yes',NULL,'No') create_debit_memo_from_rts
                   , gcckl.concatenated_segments liability_account
                   , gcckp.concatenated_segments prepay_account
                   , aps.PAYMENT_METHOD_LOOKUP_CODE default_payment_method_at_site
                   , at.name Payment_Terms              
                   ,(SELECT flv.meaning FROM fnd_lookup_values_vl flv WHERE flv.lookup_code= assa.terms_date_basis AND lookup_type= 'TERMS DATE BASIS' AND rownum = 1) term_date_basis
                   , hps.party_site_name address_name
                   , assa.address_line1
                   , assa.address_line2
                   , assa.address_line3
                   , assa.city
                   , assa.state
                   , (SELECT flv.meaning FROM fnd_lookup_values flv WHERE flv.lookup_code = assa.country AND lookup_type = 'PER_US_COUNTRY_CODE' AND rownum = 1) country
                   , hpb.party_name  bank_name
                   , hpbb.party_name bank_branch_name
                   , ieba.bank_account_name bank_acc_name
                   , ieba.bank_account_num bank_acc_number              
                   , ieba.iban
                  , NVL(jcv.approved_invoice_flag,'N') Tds_Invoice_CM_Flag
                  , jat.tds_vendor_type_lookup_code
                  , jat.pan_no
                  , jat.tan_no
                  , jat.confirm_pan_flag
                  , jat.section_code Default_TDS_Section
                  , (SELECT jct.tax_name FROM jai_cmn_taxes_all jct WHERE jct.tax_id = jat.tax_id) Tax_Name
      FROM ap_suppliers aps
                   , ap_supplier_sites_all assa      
                   , hr_operating_units hou
                   , ap_terms at
                   , iby_payment_methods_vl ipm
                   , hz_parties hp
                   , hz_party_sites hps
                   , iby_external_payees_all iepa
                   , iby_pmt_instr_uses_all ipiua
                   , iby_ext_bank_accounts ieba
                   , hz_parties hpb
                   , hz_parties hpbb
                   , gl_code_combinations_kfv gcckp
                   , gl_code_combinations_kfv gcckl  
                   ,  jai_cmn_vendor_sites    jcv
                  ,  jai_ap_tds_vendor_hdrs  jat          
     WHERE 1=1
        AND aps.vendor_id = assa.vendor_id
        AND assa.org_id = hou.organization_id
        AND assa.terms_id = at.term_id(+)
        AND aps.payment_method_lookup_code   =    ipm.payment_method_code(+)
        AND aps.party_id = hp.party_id
        AND hp.party_id = hps.party_id
        AND assa.party_site_id = hps.party_site_id
        AND aps.party_id = iepa.payee_party_id
        AND assa.party_site_id = iepa.party_site_id(+)
        AND assa.vendor_site_id = iepa.supplier_site_id(+)
        AND iepa.ext_payee_id=ipiua.ext_pmt_party_id(+)
        AND ipiua.instrument_id = ieba.ext_bank_account_id(+)
        AND ieba.bank_id = hpb.party_id(+)
        AND ieba.branch_id = hpbb.party_id(+)
        AND assa.prepay_code_combination_id = gcckp.code_combination_id(+)
        AND assa.accts_pay_code_combination_id = gcckl.code_combination_id(+)
        AND assa.vendor_id      = jcv.vendor_id(+)
        AND assa.vendor_site_id = jcv.vendor_site_id(+)
        AND jcv.vendor_id = jat.vendor_id(+)
        AND jcv.vendor_site_id = jat.vendor_site_id(+)
        AND aps.end_date_active IS NULL
        AND aps.vendor_name LIKE :P_VENDOR_NAME
       ORDER BY 1,2 ,3
       
       
       
     
  5. siva551

    siva551 Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    75
    Hi teiaswil,
    could u please send me code of supplier bank conversion.

    Thanks&Regards,
    Siva
     
  6. Tejaswil

    Tejaswil Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi Sambasiva,

    Yes, Bank details are showing through that query given by you. bt, in front end its nt showing.


    Thanks
     
  7. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    Supplier sites are be Operating unit specific. So Check the operating unit and Responsibility.

    Regards
    Sambasiva Reddy. K