aia.invoice_id,
aia.invoice_num,
aila.line_number,
zlv.TRX_LINE_NUMBER,
zlv.TRX_ID,
zlv.TAX_AMT_TAX_CURR,
zlv.TAX_AMT,
zlv.TAXABLE_AMT,
zlv.TAXABLE_AMT_TAX_CURR
from
ap_invoices_all aia,
ap_invoice_lines_all aila,
zx_lines_v zlv
where 1=1
and aia.invoice_id = aila.invoice_id
and aila.invoice_id = zlv.trx_id
and aila.line_number = zlv.trx_line_number
and aia.invoice_num = '<>'
Oracle Apps R12 and Fusion Cloud Self Paced Training Videos Published on Udemy with Live Meeting Support. Please Check https://www.oracleappstechnical.com
ReplyDelete