Select distinct
AIA.INVOICE_NUM
, AIA.INVOICE_DATE
, JTD.TAX_CATEGORY_NAME GST_TAX_CAT
, JTD.LINE_AMT
from
APPS.JAI_TAX_DET_FCT_LINES_V JTD
, AP_INVOICES_ALL AIA
where
AIA.INVOICE_ID =:P_INVOICE_ID
and JTD.TRX_NUMBER = AIA.INVOICE_NUM
and JTD.TAX_CATEGORY_NAME like 'GST%'
AIA.INVOICE_NUM
, AIA.INVOICE_DATE
, JTD.TAX_CATEGORY_NAME GST_TAX_CAT
, JTD.LINE_AMT
from
APPS.JAI_TAX_DET_FCT_LINES_V JTD
, AP_INVOICES_ALL AIA
where
AIA.INVOICE_ID =:P_INVOICE_ID
and JTD.TRX_NUMBER = AIA.INVOICE_NUM
and JTD.TAX_CATEGORY_NAME like 'GST%'