Financials for India - EBS (MOSC)

MOSC Banner

Join between gl_code_combinations and India GST Query?

edited Dec 15, 2017 4:59AM in Financials for India - EBS (MOSC) 4 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center