[Home] [Help]
2390: nvl2(taxlines_gt.tax_rate_code,
2391: CASE WHEN (sd_rates.tax_regime_code is not null and
2392: rate.tax_rate_code is not NULL )
2393: THEN CASE WHEN taxlines_gt.tax_rate_id IS NOT NULL
2394: AND NOT EXISTS ( SELECT 1 FROM zx_rates_b
2395: WHERE tax_rate_id = taxlines_gt.tax_rate_id)
2396: THEN 'Y'
2397: ELSE 'N' END
2398: ELSE 'Y' END,
2400: -- Check for Rate Code Effective
2401: nvl2(taxlines_gt.tax_rate_code,
2402: CASE WHEN rate.effective_to IS NOT NULL AND
2403: (header.trx_date NOT BETWEEN rate.effective_from AND rate.effective_to) AND
2404: NOT EXISTS (SELECT 1 FROM zx_rates_b zrb
2405: WHERE zrb.tax_rate_code = rate.tax_rate_code
2406: AND zrb.tax_regime_code = rate.tax_regime_code
2407: AND zrb.tax = rate.tax
2408: AND zrb.tax_status_code = rate.tax_status_code
2419: nvl2(taxlines_gt.tax_rate_code,
2420: CASE WHEN rate.active_flag = 'N' AND
2421: (header.trx_date BETWEEN rate.effective_from AND
2422: nvl(rate.effective_to,header.trx_date)) AND
2423: NOT EXISTS (SELECT 1 FROM zx_rates_b zrb
2424: WHERE zrb.tax_rate_code = rate.tax_rate_code
2425: AND zrb.tax_regime_code = rate.tax_regime_code
2426: AND zrb.tax = rate.tax
2427: AND zrb.tax_status_code = rate.tax_status_code
2445: THEN 'Y'
2446: ELSE 'N' END,
2447: 'N') TAX_RATE_PERCENTAGE_INVALID
2448: FROM ZX_TRX_HEADERS_GT header,
2449: ZX_RATES_B rate ,
2450: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2451: ZX_TRANSACTION_LINES_GT lines_gt,
2452: ZX_SUBSCRIPTION_DETAILS sd_rates
2453: WHERE taxlines_gt.trx_id = header.trx_id
2479: AND (NVL(sd_rates.view_options_code,'NONE') IN ('NONE', 'VFC')
2480: OR (NVL(sd_rates.view_options_code, 'VFR') = 'VFR'
2481: AND NOT EXISTS
2482: (SELECT 1
2483: FROM zx_rates_b b
2484: WHERE b.tax_regime_code = rate.tax_regime_code
2485: AND b.tax = rate.tax
2486: AND b.tax_status_code = rate.tax_status_code
2487: AND b.tax_rate_code = rate.tax_rate_code