0 Replies Latest reply on Jul 30, 2013 4:45 PM by user11655073

    I want to show attachment details in PO Print Report with respect to po revision in which attachment was added?

    user11655073

      Hello,

       

      I have developed a report which show PO details with respective PO Revision Number.

      PO revision number is the parameter. Whatever revision number I select details of PO for that particular revision no got displayed.

       

      User used to update document whenever there is any amendment in the PO. This information is stored in 'fnd_documents_long_text' table.

      User want to display respective long_text for that particular revision.

       

      Example:

      PO Revision: 0

      long text :

       

      PO Revision :1

      long text: amendment 1 due to item A added

       

      PO Revision :2

      long text: amendment 2 due to price of item A has been updated

       

      So when I select revision 0 then no long text will be displayed

           when I select revision 1 then long text added during revision 1 should be displayed

           when I select revision 2 then long text from all the revisions should be displayed.

       

       

       

      Thanks all for your valuable support.

       

      Regards

      Sunny