Join between gl_code_combinations and India GST Query?
Hi All,
How to join gl_code_combinations and below queries.
Oracle Apps R12.1.3 , India GST
SELECT *
FROM jai_tax_lines_all jtl,
jai_tax_rates jtr,
jai_reporting_types jrt,
ja_lookups exemption_type
WHERE jtl.tax_rate_id = jtr.tax_rate_id(+)
AND jtl.reporting_type_id = jrt.reporting_type_id(+)
AND exemption_type.lookup_type(+) = 'JAI_EXEMPTION_TYPE'
AND jtl.exemption_type = exemption_type.lookup_code(+)
AND jtl.trx_id = 255599
AND Trim(jtl.tax_rate_code) LIKE 'SGST%'
AND jtl.org_id = 111;