0 Replies Latest reply on Mar 19, 2015 5:34 AM by Uva

    Join between ZX_LINES_V and AP_INVOICE_LINES_ALL

    Uva

      Hi All,

       

      I need to identify the TAX_RATE for each 'ITEM' line in AP.

       

      We can link the ZX_LINES_V and AP_INVOICE_LINES_ALL right?

       

      I know that TRX_ID is INVOICE_ID but how to identify for which corresponding LINE

      is ZX_LINES_V.TRX_LINE_ID = AP_INVOICE_LINES_ALL.LINE_NUMBER ?

       

      Could you pls confirm this.

       

      Thanks in advance.

      Regards,

      Uva.