eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_VALIDATE_API_PKG dependencies on ZX_TAXES_B

Line 1758: ZX_TAXES_B tax,

1754: FROM ZX_TRX_TAX_LINK_GT TaxLink,
1755: ZX_IMPORT_TAX_LINES_GT TaxLines,
1756: ZX_TRX_HEADERS_GT Header,
1757: ZX_TRANSACTION_LINES_GT Lines,
1758: ZX_TAXES_B tax,
1759: zx_rates_b rate,
1760: zx_subscription_details sd_tax,
1761: zx_subscription_details sd_rates
1762: WHERE Taxlines.TAX_LINE_ALLOCATION_FLAG = 'Y'

Line 1842: FROM ZX_TAXES_B

1838: header.trx_date,
1839: SYSDATE) )
1840: OR
1841: tax.effective_from = (SELECT MIN(effective_from)
1842: FROM ZX_TAXES_B
1843: WHERE
1844: tax_regime_code = tax.tax_regime_code and
1845: tax = tax.tax and
1846: content_owner_id = tax.content_owner_id

Line 1851: AND NOT EXISTS (SELECT 1 FROM zx_taxes_b b

1847: )
1848: )
1849: and (nvl(sd_tax.view_options_code,'NONE') in ('NONE', 'VFC') OR
1850: (nvl(sd_tax.view_options_code,'VFR') = 'VFR'
1851: AND NOT EXISTS (SELECT 1 FROM zx_taxes_b b
1852: WHERE tax.tax_regime_code = b.tax_regime_code
1853: AND tax.tax = b.tax
1854: AND sd_tax.first_pty_org_id = b.content_owner_id
1855: )

Line 2015: ZX_TAXES_B tax ,

2011: lines_gt.trx_level_type,
2012: taxlines_gt.summary_tax_line_number
2013: FROM ZX_TRX_HEADERS_GT header,
2014: ZX_REGIMES_B regime ,
2015: ZX_TAXES_B tax ,
2016: ZX_STATUS_B status ,
2017: -- ZX_RATES_B rate ,
2018: -- zx_rates_b off_rate,
2019: -- zx_import_tax_lines_gt temp_gt,

Line 2126: FROM ZX_TAXES_B

2122: /*OR tax.effective_from =
2123: (
2124: SELECT
2125: min(effective_from)
2126: FROM ZX_TAXES_B
2127: WHERE tax_regime_code = tax.tax_regime_code
2128: AND tax = tax.tax
2129: AND content_owner_id = tax.content_owner_id
2130: ) */

Line 2141: FROM zx_taxes_b b

2137: nvl(sd_tax.view_options_code,'VFR') = 'VFR'
2138: AND not exists
2139: (
2140: SELECT 1
2141: FROM zx_taxes_b b
2142: WHERE tax.tax_regime_code = b.tax_regime_code
2143: AND tax.tax = b.tax
2144: AND sd_tax.first_pty_org_id = b.content_owner_id
2145: )

Line 4517: AND (EXISTS (SELECT 1 FROM ZX_TAXES_B

4513:
4514: --Commented for Bug#7504455--
4515: /*CASE WHEN /*(lines_gt.output_tax_classification_code IS NOT NULL OR
4516: lines_gt.input_tax_classification_code IS NOT NULL)
4517: AND (EXISTS (SELECT 1 FROM ZX_TAXES_B
4518: WHERE TAX_TYPE_CODE = 'OFFSET'
4519: AND tax IN (SELECT tax FROM ZX_RATES_B
4520: WHERE tax_rate_code = NVL(lines_gt.output_tax_classification_code,
4521: lines_gt.input_tax_classification_code)))

Line 5424: ZX_TAXES_B tax ,

5420:
5421: /* end bug 3676878 */
5422: FROM ZX_TRX_HEADERS_GT header,
5423: ZX_REGIMES_B regime ,
5424: ZX_TAXES_B tax ,
5425: ZX_STATUS_B status ,
5426: -- ZX_RATES_B rate ,
5427: -- zx_rates_b off_rate,
5428: -- zx_import_tax_lines_gt temp_gt,

Line 5538: FROM ZX_TAXES_B

5534: /*OR tax.effective_from =
5535: (
5536: SELECT
5537: min(effective_from)
5538: FROM ZX_TAXES_B
5539: WHERE tax_regime_code = tax.tax_regime_code
5540: AND tax = tax.tax
5541: AND content_owner_id = tax.content_owner_id
5542: ) */

Line 5553: FROM zx_taxes_b b

5549: nvl(sd_tax.view_options_code,'VFR') = 'VFR'
5550: AND not exists
5551: (
5552: SELECT 1
5553: FROM zx_taxes_b b
5554: WHERE tax.tax_regime_code = b.tax_regime_code
5555: AND tax.tax = b.tax
5556: AND sd_tax.first_pty_org_id = b.content_owner_id
5557: )

Line 7449: AND NOT EXISTS( SELECT 1 FROM zx_taxes_b ztb

7445: AND taxlines_gt.subscription_date
7446: BETWEEN NVL(ZSD.effective_from,taxlines_gt.subscription_date)
7447: AND NVL(ZSD.effective_to, taxlines_gt.subscription_date)
7448: )
7449: AND NOT EXISTS( SELECT 1 FROM zx_taxes_b ztb
7450: WHERE ztb.tax_regime_code = tax.tax_regime_code
7451: AND ztb.tax = tax.tax
7452: AND ztb.content_owner_id IN (g_first_pty_org_id,-99)
7453: AND ztb.live_for_processing_flag = 'Y'

Line 7495: ZX_TAXES_B tax ,

7491: zx_trx_headers_gt header,
7492: --zx_transaction_lines_gt lines_gt,
7493: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
7494: ZX_REGIMES_B regime ,
7495: ZX_TAXES_B tax ,
7496: ZX_STATUS_B status ,
7497: zx_subscription_details sd_reg,
7498: zx_subscription_details sd_tax,
7499: zx_subscription_details sd_status

Line 7570: FROM zx_taxes_b b

7566: OR (
7567: nvl(sd_tax.view_options_code,'VFR') = 'VFR'
7568: AND not exists (
7569: SELECT 1
7570: FROM zx_taxes_b b
7571: WHERE tax.tax_regime_code = b.tax_regime_code
7572: AND tax.tax = b.tax
7573: AND sd_tax.first_pty_org_id = b.content_owner_id
7574: )