1 Reply Latest reply on May 6, 2011 7:30 AM by santhosh177230

    How to populate view

    user021
      Could you please any body share the package through we can populate Payable view like ap_invoice_distributions_v.

      --thanks                                                                                                                                                                                                                                                           
        • 1. Re: How to populate view
          santhosh177230
          Hi,

          I hope you are in R12.

          Before using this view in sql query. Just initialize the ORG_ID by below package

          begin
          mo_global.set_policy_context('S',org_id);
          end;

          select * from apps.ap_invoice_distributions_v where rownum<=2

          Hope this will help you

          Thanks
          --Sandy.