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_TAX_CONTENT_UPLOAD dependencies on ZX_RATES_B

Line 1642: ZX_RATES_B zrb

1638: AND NVL(jur.county_jurisdiction_code,'-1') = NVL(v.county_jurisdiction_code,'-1')
1639: AND NVL(jur.city_jurisdiction_code,'-1') = NVL(v.city_jurisdiction_code,'-1')
1640: AND NVL(jur.primary_flag,'Y') = 'Y'
1641: AND jur.effective_to IS NULL) v1,
1642: ZX_RATES_B zrb
1643: WHERE zrb.tax_regime_code(+) = v1.tax_regime_code
1644: AND zrb.tax(+) = v1.tax
1645: AND zrb.content_owner_id(+) = v1.content_owner_id
1646: AND zrb.tax_jurisdiction_code(+) = v1.tax_jurisdiction_code

Line 1740: ZX_RATES_B zrb

1736: AND NVL(jur.county_jurisdiction_code,'-1') = NVL(v.county_jurisdiction_code,'-1')
1737: AND NVL(jur.city_jurisdiction_code,'-1') = NVL(v.city_jurisdiction_code,'-1')
1738: AND NVL(jur.primary_flag,'Y') = 'Y'
1739: AND jur.effective_to IS NULL) v1,
1740: ZX_RATES_B zrb
1741: WHERE zrb.content_owner_id = v1.content_owner_id
1742: AND zrb.tax_jurisdiction_code = v1.tax_jurisdiction_code
1743: AND zrb.tax_rate_code = v1.tax_rate_code
1744: AND zrb.active_flag = v1.active_flag

Line 2108: UPDATE zx_rates_b_tmp

2104: END LOOP;
2105:
2106: -- Start : Added for Bug#7298430
2107: FORALL i IN INDICES OF l_rates_rec.tax_rate_id
2108: UPDATE zx_rates_b_tmp
2109: SET active_flag = l_rates_rec.active_flag(i),
2110: effective_from = l_rates_rec.effective_from(i),
2111: effective_to = l_rates_rec.effective_to(i),
2112: default_flg_effective_from = l_rates_rec.effective_from(i),

Line 5090: MERGE INTO ZX_RATES_B_TMP zrbt

5086: FND_FILE.LOG,
5087: 'Creating/Updating Tax Rates - 1.'
5088: );
5089:
5090: MERGE INTO ZX_RATES_B_TMP zrbt
5091: USING (SELECT tax_regime_code,
5092: tax,
5093: content_owner_id,
5094: tax_status_code,

Line 5171: FROM zx_rates_b

5167: decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE') ,
5168: decode(greatest(rt.effective_from,G_RECORD_EFFECTIVE_START),rt.effective_from,rt.effective_from,G_RECORD_EFFECTIVE_START)
5169: ) AS RATE_COUNT,
5170: (SELECT Count(*)
5171: FROM zx_rates_b
5172: WHERE TAX_REGIME_CODE = p_tax_regime_code
5173: AND tax = decode(to_char(rt.record_type),'9',rt.sales_tax_authority_level,'10',rt.rental_tax_authority_level,'11',rt.use_tax_authority_level,'12',rt.lease_tax_authority_level)
5174: AND tax_status_code = 'STANDARD'
5175: AND content_owner_id = -99

Line 5250: zx_rates_b_s.nextval,

5246: zrbt.LAST_UPDATE_LOGIN
5247: )
5248: VALUES
5249: (
5250: zx_rates_b_s.nextval,
5251: 1,
5252: v.TAX_RATE_CODE,
5253: v.TAX_REGIME_CODE,
5254: v.TAX,

Line 5302: MERGE INTO ZX_RATES_B_TMP zrbt

5298: FND_FILE.LOG,
5299: 'Creating/Updating Tax Rates - 2.'
5300: );
5301:
5302: MERGE INTO ZX_RATES_B_TMP zrbt
5303: USING (SELECT tax_regime_code,
5304: tax,
5305: content_owner_id,
5306: tax_status_code,

Line 5383: FROM zx_rates_b

5379: decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE') ,
5380: decode(greatest(rt.effective_from,G_RECORD_EFFECTIVE_START),rt.effective_from,rt.effective_from,G_RECORD_EFFECTIVE_START)
5381: ) AS RATE_COUNT,
5382: (SELECT Count(*)
5383: FROM zx_rates_b
5384: WHERE TAX_REGIME_CODE = p_tax_regime_code
5385: AND tax = decode(to_char(rt.record_type),'9',rt.sales_tax_authority_level,'10',rt.rental_tax_authority_level,'11',rt.use_tax_authority_level,'12',rt.lease_tax_authority_level)
5386: AND tax_status_code = 'STANDARD'
5387: AND content_owner_id = -99

Line 5464: zx_rates_b_s.nextval,

5460: zrbt.LAST_UPDATE_LOGIN
5461: )
5462: VALUES
5463: (
5464: zx_rates_b_s.nextval,
5465: 1,
5466: v.TAX_RATE_CODE,
5467: v.TAX_REGIME_CODE,
5468: v.TAX,

Line 5514: INSERT ALL INTO ZX_RATES_B_TMP

5510: FND_FILE.LOG,
5511: 'Creating Tax Rates with NULL Tax Jurisdiction.'
5512: );
5513:
5514: INSERT ALL INTO ZX_RATES_B_TMP
5515: (
5516: TAX_RATE_ID,
5517: OBJECT_VERSION_NUMBER,
5518: TAX_RATE_CODE,

Line 5543: zx_rates_b_s.nextval,

5539: LAST_UPDATE_LOGIN
5540: )
5541: VALUES
5542: (
5543: zx_rates_b_s.nextval,
5544: 1,
5545: TAX,
5546: TAX_REGIME_CODE,
5547: TAX,

Line 5575: AND NOT EXISTS (SELECT 1 FROM ZX_RATES_B rate

5571: FROM ZX_TAXES_B tax
5572: WHERE tax.TAX_REGIME_CODE = p_tax_regime_code
5573: AND tax.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
5574: AND tax.CONTENT_OWNER_ID = -99 -- Condition Added as a fix for Bug#8286647
5575: AND NOT EXISTS (SELECT 1 FROM ZX_RATES_B rate
5576: WHERE rate.TAX_RATE_CODE = tax.TAX
5577: AND rate.CONTENT_OWNER_ID = -99
5578: AND rate.TAX_JURISDICTION_CODE IS NULL
5579: AND rate.EFFECTIVE_FROM = tax.EFFECTIVE_FROM

Line 5647: FROM ZX_RATES_B zrb,

5643: sysdate,
5644: fnd_global.user_id,
5645: sysdate,
5646: fnd_global.conc_login_id
5647: FROM ZX_RATES_B zrb,
5648: ZX_JURISDICTIONS_B zjb,
5649: ZX_ACCOUNTS za
5650: WHERE zrb.TAX_REGIME_CODE = p_tax_regime_code
5651: AND zrb.TAX IN ('STATE','COUNTY','CITY')

Line 5696: FROM ZX_RATES_B zrb,

5692: sysdate,
5693: fnd_global.conc_login_id,
5694: fl.LANGUAGE_CODE,
5695: USERENV('LANG')
5696: FROM ZX_RATES_B zrb,
5697: FND_LANGUAGES fl
5698: WHERE fl.INSTALLED_FLAG IN ('I', 'B')
5699: AND zrb.TAX_REGIME_CODE = p_tax_regime_code
5700: AND zrb.CONTENT_OWNER_ID = -99

Line 5722: FROM ZX_RATES_B rate

5718: WHERE tax.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
5719: AND tax.TAX_REGIME_CODE = p_tax_regime_code
5720: AND tax.CONTENT_OWNER_ID = -99 -- Condition Added as a fix for Bug#8286647
5721: AND EXISTS (SELECT 1
5722: FROM ZX_RATES_B rate
5723: WHERE rate.TAX_REGIME_CODE = tax.TAX_REGIME_CODE
5724: AND rate.TAX = tax.TAX
5725: AND rate.CONTENT_OWNER_ID = -99 -- Condition Added as a fix for Bug#8286647
5726: AND rate.RECORD_TYPE_CODE = G_CREATED_BY_MODULE);