Clarity PPM

Expand all | Collapse all

Hi All, I want to map PONO from PPA_WIPAPINFO with  invoiceno  of PPA_WIP table.

  • 1.  Hi All, I want to map PONO from PPA_WIPAPINFO with  invoiceno  of PPA_WIP table.

    Posted 10-27-2015 07:15 AM

    Hi All,

    I have imported PO Number from outsie of clarity through interface, and now it is in PPA_WIPAPINFO,

    But as per requirement i want to Map that po number with invoiceno of PPA_WIP table,

    So now How would i map the PONO from PPA_WIPAPINFO with invoiceno of PPA_WIP table.

     

    Regards,

    Amol



  • 2.  Re: Hi All, I want to map PONO from PPA_WIPAPINFO with  invoiceno  of PPA_WIP table.

    Posted 11-24-2015 01:26 PM

    The 2 tables can be joined in the following manner:

     

    SELECT AP.VOUCHERNO, AP.PONO, AP.VENDOR_CODE, W.*

    FROM PPA_WIPAPINFO AP, PPA_WIP W

    WHERE AP.ID = W.PPA_WIPAPINFO_ID

     

    The PPA_WIPAPINFO.PONO number is from XOG or Voucher Transaction Entry transactions (not used in Timesheet transactions)

    The PPA_WIP.INVOICE number is generated from the use of chargeback invoices.