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 1386: ZX_RATES_B zrb

1382: AND jur.state_jurisdiction_code = v.state_jurisdiction_code
1383: AND NVL(jur.county_jurisdiction_code,'-1') = NVL(v.county_jurisdiction_code,'-1')
1384: AND NVL(jur.city_jurisdiction_code,'-1') = NVL(v.city_jurisdiction_code,'-1')
1385: AND jur.effective_to IS NULL) v1,
1386: ZX_RATES_B zrb
1387: WHERE zrb.tax_regime_code(+) = v1.tax_regime_code
1388: AND zrb.tax(+) = v1.tax
1389: AND zrb.content_owner_id(+) = v1.content_owner_id
1390: AND zrb.tax_jurisdiction_code(+) = v1.tax_jurisdiction_code

Line 1464: ZX_RATES_B zrb

1460: AND jur.state_jurisdiction_code = v.state_jurisdiction_code
1461: AND NVL(jur.county_jurisdiction_code,'-1') = NVL(v.county_jurisdiction_code,'-1')
1462: AND NVL(jur.city_jurisdiction_code,'-1') = NVL(v.city_jurisdiction_code,'-1')
1463: AND jur.effective_to IS NULL) v1,
1464: ZX_RATES_B zrb
1465: WHERE zrb.content_owner_id = v1.content_owner_id
1466: AND zrb.tax_jurisdiction_code = v1.tax_jurisdiction_code
1467: AND zrb.tax_rate_code = v1.tax_rate_code
1468: AND zrb.active_flag = v1.active_flag

Line 1826: UPDATE zx_rates_b_tmp

1822: END LOOP;
1823:
1824: -- Start : Added for Bug#7298430
1825: FORALL i IN INDICES OF l_rates_rec.tax_rate_id
1826: UPDATE zx_rates_b_tmp
1827: SET effective_from = l_rates_rec.effective_from(i),
1828: effective_to = l_rates_rec.effective_to(i),
1829: default_flg_effective_from = l_rates_rec.effective_from(i),
1830: default_flg_effective_to = l_rates_rec.effective_to(i)

Line 4699: MERGE INTO ZX_RATES_B_TMP zrbt

4695:
4696:
4697: WHILE (l_any_rows_to_process)
4698: LOOP**/
4699: MERGE INTO ZX_RATES_B_TMP zrbt
4700: USING (SELECT tax_regime_code,
4701: tax,
4702: content_owner_id,
4703: tax_status_code,

Line 4764: FROM zx_rates_b

4760: decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE') ,
4761: decode(greatest(rt.effective_from,G_RECORD_EFFECTIVE_START),rt.effective_from,rt.effective_from,G_RECORD_EFFECTIVE_START)
4762: ) AS RATE_COUNT,
4763: (SELECT Count(*)
4764: FROM zx_rates_b
4765: WHERE TAX_REGIME_CODE = p_tax_regime_code
4766: 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)
4767: AND tax_status_code = 'STANDARD'
4768: AND content_owner_id = -99

Line 4834: zx_rates_b_s.nextval,

4830: zrbt.LAST_UPDATE_LOGIN
4831: )
4832: VALUES
4833: (
4834: zx_rates_b_s.nextval,
4835: 1,
4836: v.TAX_RATE_CODE,
4837: v.TAX_REGIME_CODE,
4838: v.TAX,

Line 4874: MERGE INTO ZX_RATES_B_TMP zrbt

4870: -- added this to ensure that when we have two rate records with same effectivity, then
4871: -- active_flag is not updated as it needs to be included in the ON clause
4872: -- also need to update percentage_rate for this case.
4873:
4874: MERGE INTO ZX_RATES_B_TMP zrbt
4875: USING (SELECT tax_regime_code,
4876: tax,
4877: content_owner_id,
4878: tax_status_code,

Line 4939: FROM zx_rates_b

4935: decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE') ,
4936: decode(greatest(rt.effective_from,G_RECORD_EFFECTIVE_START),rt.effective_from,rt.effective_from,G_RECORD_EFFECTIVE_START)
4937: ) AS RATE_COUNT,
4938: (SELECT Count(*)
4939: FROM zx_rates_b
4940: WHERE TAX_REGIME_CODE = p_tax_regime_code
4941: 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)
4942: AND tax_status_code = 'STANDARD'
4943: AND content_owner_id = -99

Line 5011: zx_rates_b_s.nextval,

5007: zrbt.LAST_UPDATE_LOGIN
5008: )
5009: VALUES
5010: (
5011: zx_rates_b_s.nextval,
5012: 1,
5013: v.TAX_RATE_CODE,
5014: v.TAX_REGIME_CODE,
5015: v.TAX,

Line 5048: INSERT ALL INTO ZX_RATES_B_TMP

5044: l_rows_processed := SQL%ROWCOUNT;
5045:
5046: -- Create rates with NULL Jurisdiction codes
5047: -- Used for Partner tax calculation.
5048: INSERT ALL INTO ZX_RATES_B_TMP
5049: (
5050: TAX_RATE_ID,
5051: OBJECT_VERSION_NUMBER,
5052: TAX_RATE_CODE,

Line 5077: zx_rates_b_s.nextval,

5073: LAST_UPDATE_LOGIN
5074: )
5075: VALUES
5076: (
5077: zx_rates_b_s.nextval,
5078: 1,
5079: TAX,
5080: TAX_REGIME_CODE,
5081: TAX,

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

5104: tax.EFFECTIVE_FROM EFFECTIVE_FROM
5105: FROM ZX_TAXES_B tax
5106: WHERE tax.TAX_REGIME_CODE = p_tax_regime_code
5107: AND tax.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
5108: AND NOT EXISTS (SELECT 1 FROM ZX_RATES_B rate
5109: WHERE rate.TAX_RATE_CODE = tax.TAX
5110: AND rate.CONTENT_OWNER_ID = -99
5111: AND rate.TAX_JURISDICTION_CODE IS NULL
5112: AND rate.EFFECTIVE_FROM = tax.EFFECTIVE_FROM

Line 5168: FROM ZX_RATES_B zrb,

5164: sysdate,
5165: fnd_global.user_id,
5166: sysdate,
5167: fnd_global.conc_login_id
5168: FROM ZX_RATES_B zrb,
5169: ZX_JURISDICTIONS_B zjb,
5170: ZX_ACCOUNTS za
5171: WHERE zrb.TAX_REGIME_CODE = p_tax_regime_code
5172: AND zrb.TAX IN ('STATE','COUNTY','CITY')

Line 5205: FROM ZX_RATES_B zrb,

5201: sysdate,
5202: fnd_global.conc_login_id,
5203: fl.LANGUAGE_CODE,
5204: USERENV('LANG')
5205: FROM ZX_RATES_B zrb,
5206: FND_LANGUAGES fl
5207: WHERE fl.INSTALLED_FLAG IN ('I', 'B')
5208: AND zrb.TAX_REGIME_CODE = p_tax_regime_code
5209: AND zrb.CONTENT_OWNER_ID = -99

Line 5224: FROM ZX_RATES_B rate

5220: SET tax.LIVE_FOR_PROCESSING_FLAG = 'Y'
5221: WHERE tax.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
5222: AND tax.TAX_REGIME_CODE = p_tax_regime_code
5223: AND EXISTS (SELECT 1
5224: FROM ZX_RATES_B rate
5225: WHERE rate.TAX_REGIME_CODE = tax.TAX_REGIME_CODE
5226: AND rate.TAX = tax.TAX
5227: AND rate.RECORD_TYPE_CODE = G_CREATED_BY_MODULE);
5228: