Clarity

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

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.