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 STANDARD

Line 269: 'STANDARD_TC' , -- DEF_TAX_CALC_FORMULA

265: 'Y' , -- HAS_OTHER_JURISDICTIONS_FLAG
266: 'Y' , -- ALLOW_EXEMPTIONS_FLAG
267: 'Y' , -- ALLOW_EXCEPTIONS_FLAG
268: 'N' , -- ALLOW_RECOVERABILITY_FLAG
269: 'STANDARD_TC' , -- DEF_TAX_CALC_FORMULA
270: 'N' , -- TAX_INCLUSIVE_OVERRIDE_FLAG
271: 'STANDARD_TB' , -- DEF_TAXABLE_BASIS_FORMULA
272: 'SHIP_TO_PARTY' , -- DEF_REGISTR_PARTY_TYPE_CODE
273: 'N' , -- REGISTRATION_TYPE_RULE_FLAG

Line 271: 'STANDARD_TB' , -- DEF_TAXABLE_BASIS_FORMULA

267: 'Y' , -- ALLOW_EXCEPTIONS_FLAG
268: 'N' , -- ALLOW_RECOVERABILITY_FLAG
269: 'STANDARD_TC' , -- DEF_TAX_CALC_FORMULA
270: 'N' , -- TAX_INCLUSIVE_OVERRIDE_FLAG
271: 'STANDARD_TB' , -- DEF_TAXABLE_BASIS_FORMULA
272: 'SHIP_TO_PARTY' , -- DEF_REGISTR_PARTY_TYPE_CODE
273: 'N' , -- REGISTRATION_TYPE_RULE_FLAG
274: 'N' , -- REPORTING_ONLY_FLAG
275: 'N' , -- AUTO_PRVN_FLAG

Line 377: OPEN c_tax_status_exists(p_tax_regime_code,l_tax,-99,'STANDARD');

373:
374: END IF;
375:
376: l_exists_flag := 'N';
377: OPEN c_tax_status_exists(p_tax_regime_code,l_tax,-99,'STANDARD');
378: FETCH c_tax_status_exists
379: INTO l_exists_flag;
380: CLOSE c_tax_status_exists;
381:

Line 388: 'Creating STANDARD Status for Tax: '||l_tax||'.'

384:
385: FND_FILE.PUT_LINE
386: (
387: FND_FILE.LOG,
388: 'Creating STANDARD Status for Tax: '||l_tax||'.'
389: );
390:
391:
392: INSERT INTO ZX_STATUS_B_TMP

Line 437: 'STANDARD', --TAX_STATUS_CODE

433: )
434: VALUES
435: (
436: ZX_STATUS_B_S.NEXTVAL, --TAX_STATUS_ID
437: 'STANDARD', --TAX_STATUS_CODE
438: -99, --CONTENT_OWNER_ID
439: G_RECORD_EFFECTIVE_START,--EFFECTIVE_FROM
440: NULL, --EFFECTIVE_TO
441: l_tax, --TAX

Line 492: 'STANDARD' ,

488: )
489: SELECT
490: fl.LANGUAGE_CODE ,
491: USERENV('LANG') ,
492: 'STANDARD' ,
493: fnd_global.user_id , -- CREATED_BY
494: SYSDATE , -- CREATION_DATE
495: fnd_global.user_id , -- LAST_UPDATED_BY
496: SYSDATE , -- LAST_UPDATE_DATE

Line 505: AND zsb.TAX_STATUS_CODE = 'STANDARD';

501: WHERE fl.INSTALLED_FLAG IN ('I', 'B')
502: AND zsb.TAX_REGIME_CODE = p_tax_regime_code
503: AND zsb.CONTENT_OWNER_ID = -99
504: AND zsb.TAX = l_tax
505: AND zsb.TAX_STATUS_CODE = 'STANDARD';
506:
507: END IF;
508:
509: END LOOP;

Line 1367: 'STANDARD' tax_status_code,

1363: state_jurisdiction_code,
1364: p_tax_regime_code tax_regime_code,
1365: decode(to_char(record_type),'9',sales_tax_authority_level,'10',rental_tax_authority_level,'11',use_tax_authority_level,'12',lease_tax_authority_level) tax,
1366: -99 content_owner_id,
1367: 'STANDARD' tax_status_code,
1368: decode(p_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,
1369: effective_from,
1370: effective_to,
1371: 'PERCENTAGE' rate_type_code,

Line 1368: decode(p_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,

1364: p_tax_regime_code tax_regime_code,
1365: decode(to_char(record_type),'9',sales_tax_authority_level,'10',rental_tax_authority_level,'11',use_tax_authority_level,'12',lease_tax_authority_level) tax,
1366: -99 content_owner_id,
1367: 'STANDARD' tax_status_code,
1368: decode(p_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,
1369: effective_from,
1370: effective_to,
1371: 'PERCENTAGE' rate_type_code,
1372: decode(record_type,9,sales_tax_rate,10,rental_tax_rate,11,use_tax_rate,12,lease_tax_rate) percentage_rate,

Line 1448: DECODE(p_migrated_tax_regime_flag,'Y','STANDARD','STD')||DECODE(TO_CHAR(record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,

1444: county_jurisdiction_code,
1445: state_jurisdiction_code,
1446: -99 content_owner_id,
1447: DECODE(to_char(record_type),'9',sales_tax_authority_level,'10',rental_tax_authority_level,'11',use_tax_authority_level,'12',lease_tax_authority_level) tax,
1448: DECODE(p_migrated_tax_regime_flag,'Y','STANDARD','STD')||DECODE(TO_CHAR(record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,
1449: effective_from,
1450: DECODE(TO_CHAR(record_type),'9',sales_tax_rate_active_flag,'10',rental_tax_rate_active_flag,'11',use_tax_rate_active_flag,'12',lease_tax_rate_active_flag) active_flag,
1451: ROW_NUMBER()
1452: OVER(PARTITION BY RECORD_TYPE,STATE_JURISDICTION_CODE,COUNTY_JURISDICTION_CODE,CITY_JURISDICTION_CODE ORDER BY EFFECTIVE_FROM ASC) AS rate_row_num

Line 2086: 'STANDARD_NAME',

2082: VALUES
2083: (
2084: geography_id,
2085: p_tax_content_source,
2086: 'STANDARD_NAME',
2087: geography_name,
2088: 1,
2089: 'NAME',
2090: 'Y',

Line 2172: 'STANDARD_NAME',

2168: VALUES
2169: (
2170: geography_id,
2171: p_tax_content_source,
2172: 'STANDARD_NAME',
2173: geography_name1,
2174: 1,
2175: 'NAME',
2176: 'N',

Line 2211: 'STANDARD_NAME',

2207: VALUES
2208: (
2209: geography_id,
2210: p_tax_content_source,
2211: 'STANDARD_NAME',
2212: geography_name,
2213: 1,
2214: 'NAME',
2215: 'N',

Line 2288: 'STANDARD_NAME',

2284: VALUES
2285: (
2286: geography_id,
2287: p_tax_content_source,
2288: 'STANDARD_NAME',
2289: geography_name1,
2290: 1,
2291: 'NAME',
2292: 'N',

Line 2643: AND hgi.identifier_subtype = 'STANDARD_NAME'

2639: 'EXISTS' = (SELECT 'EXISTS'
2640: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi
2641: WHERE hgi.geography_id = v.geography_id
2642: AND hgi.identifier_type = 'NAME'
2643: AND hgi.identifier_subtype = 'STANDARD_NAME'
2644: AND UPPER(hgi.identifier_value) = UPPER(DECODE(geography_type,'STATE',geography_name1,geography_name)))
2645: THEN
2646: 'NOCHANGE'
2647: WHEN status = 'UPDATE'

Line 2960: 'STANDARD_NAME',

2956: VALUES
2957: (
2958: zone_geography_id,
2959: p_tax_content_source,
2960: 'STANDARD_NAME',
2961: geo_code,
2962: 1,
2963: 'NAME',
2964: 'Y',

Line 3942: 'STANDARD_NAME',

3938: VALUES
3939: (
3940: hz_geographies_s.nextval,
3941: p_tax_content_source,
3942: 'STANDARD_NAME',
3943: geography_name,
3944: 1,
3945: 'NAME',
3946: 'Y',

Line 4561: 'STANDARD_NAME',

4557: VALUES
4558: (
4559: geography_id,
4560: p_tax_content_source,
4561: 'STANDARD_NAME',
4562: geography_name,
4563: 1,
4564: 'NAME',
4565: 'N',

Line 4587: AND hgi.IDENTIFIER_SUBTYPE = 'STANDARD_NAME'

4583: AND NOT EXISTS (SELECT 1
4584: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi
4585: WHERE hgi.geography_id = inter.geography_id
4586: AND hgi.IDENTIFIER_TYPE = 'NAME'
4587: AND hgi.IDENTIFIER_SUBTYPE = 'STANDARD_NAME'
4588: AND UPPER(hgi.IDENTIFIER_VALUE) = UPPER(inter.geography_name)
4589: AND hgi.LANGUAGE_CODE = 'US');
4590:
4591: l_rows_processed := SQL%ROWCOUNT;

Line 4718: 'STANDARD' tax_status_code,

4714: (SELECT DISTINCT
4715: p_tax_regime_code tax_regime_code,
4716: 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) tax,
4717: -99 content_owner_id,
4718: 'STANDARD' tax_status_code,
4719: DECODE(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),
4720: 'STATE',decode(to_char(jur.record_type),'1','ST-','3','ST-CO-','6','ST-CI-'),
4721: 'COUNTY',decode(to_char(jur.record_type),'3','CO-','6','CO-CI-'),
4722: 'CITY','CI-')||

Line 4733: decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,

4729: '1',jur.state_jurisdiction_code||'0000000',
4730: '3',jur.state_jurisdiction_code||jur.county_jurisdiction_code||'0000',
4731: '6',jur.state_jurisdiction_code||jur.county_jurisdiction_code||LPAD(jur.city_jurisdiction_code,4,'0'))
4732: ) tax_jurisdiction_code,
4733: decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,
4734: decode(greatest(rt.effective_from,G_RECORD_EFFECTIVE_START),rt.effective_from,rt.effective_from,G_RECORD_EFFECTIVE_START) effective_from,
4735: rt.effective_to,
4736: 'PERCENTAGE' rate_type_code,
4737: decode(rt.record_type,9,rt.sales_tax_rate,10,rt.rental_tax_rate,11,rt.use_tax_rate,12,rt.lease_tax_rate) percentage_rate,

Line 4745: 'STANDARD' ,

4741: OVER (PARTITION BY
4742: p_tax_regime_code,
4743: 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) ,
4744: -99 ,
4745: 'STANDARD' ,
4746: DECODE(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),
4747: 'STATE',decode(to_char(jur.record_type),'1','ST-','3','ST-CO-','6','ST-CI-'),
4748: 'COUNTY',decode(to_char(jur.record_type),'3','CO-','6','CO-CI-'),
4749: 'CITY','CI-')||

Line 4760: decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE') ,

4756: '1',jur.state_jurisdiction_code||'0000000',
4757: '3',jur.state_jurisdiction_code||jur.county_jurisdiction_code||'0000',
4758: '6',jur.state_jurisdiction_code||jur.county_jurisdiction_code||LPAD(jur.city_jurisdiction_code,4,'0'))
4759: ) ,
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

Line 4767: AND tax_status_code = 'STANDARD'

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
4769: AND tax_jurisdiction_code = DECODE(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),
4770: 'STATE',decode(to_char(jur.record_type),'1','ST-','3','ST-CO-','6','ST-CI-'),
4771: 'COUNTY',decode(to_char(jur.record_type),'3','CO-','6','CO-CI-'),

Line 4782: AND tax_rate_code = decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE')

4778: DECODE(to_char(jur.record_type),
4779: '1',jur.state_jurisdiction_code||'0000000',
4780: '3',jur.state_jurisdiction_code||jur.county_jurisdiction_code||'0000',
4781: '6',jur.state_jurisdiction_code||jur.county_jurisdiction_code||LPAD(jur.city_jurisdiction_code,4,'0')))
4782: AND tax_rate_code = decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE')
4783: AND effective_from = decode(greatest(rt.effective_from,G_RECORD_EFFECTIVE_START),rt.effective_from,rt.effective_from,G_RECORD_EFFECTIVE_START)
4784: ) l_count
4785: FROM zx_data_upload_interface rt,
4786: zx_data_upload_interface jur

Line 4893: 'STANDARD' tax_status_code,

4889: (SELECT DISTINCT
4890: p_tax_regime_code tax_regime_code,
4891: 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) tax,
4892: -99 content_owner_id,
4893: 'STANDARD' tax_status_code,
4894: DECODE(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),
4895: 'STATE',decode(to_char(jur.record_type),'1','ST-','3','ST-CO-','6','ST-CI-'),
4896: 'COUNTY',decode(to_char(jur.record_type),'3','CO-','6','CO-CI-'),
4897: 'CITY','CI-')||

Line 4908: decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,

4904: '1',jur.state_jurisdiction_code||'0000000',
4905: '3',jur.state_jurisdiction_code||jur.county_jurisdiction_code||'0000',
4906: '6',jur.state_jurisdiction_code||jur.county_jurisdiction_code||LPAD(jur.city_jurisdiction_code,4,'0'))
4907: ) tax_jurisdiction_code,
4908: decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,
4909: decode(greatest(rt.effective_from,G_RECORD_EFFECTIVE_START),rt.effective_from,rt.effective_from,G_RECORD_EFFECTIVE_START) effective_from,
4910: rt.effective_to,
4911: 'PERCENTAGE' rate_type_code,
4912: decode(rt.record_type,9,rt.sales_tax_rate,10,rt.rental_tax_rate,11,rt.use_tax_rate,12,rt.lease_tax_rate) percentage_rate,

Line 4920: 'STANDARD' ,

4916: OVER (PARTITION BY
4917: p_tax_regime_code,
4918: 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) ,
4919: -99 ,
4920: 'STANDARD' ,
4921: DECODE(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),
4922: 'STATE',decode(to_char(jur.record_type),'1','ST-','3','ST-CO-','6','ST-CI-'),
4923: 'COUNTY',decode(to_char(jur.record_type),'3','CO-','6','CO-CI-'),
4924: 'CITY','CI-')||

Line 4935: decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE') ,

4931: '1',jur.state_jurisdiction_code||'0000000',
4932: '3',jur.state_jurisdiction_code||jur.county_jurisdiction_code||'0000',
4933: '6',jur.state_jurisdiction_code||jur.county_jurisdiction_code||LPAD(jur.city_jurisdiction_code,4,'0'))
4934: ) ,
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

Line 4942: AND tax_status_code = 'STANDARD'

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
4944: AND tax_jurisdiction_code = DECODE(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),
4945: 'STATE',decode(to_char(jur.record_type),'1','ST-','3','ST-CO-','6','ST-CI-'),
4946: 'COUNTY',decode(to_char(jur.record_type),'3','CO-','6','CO-CI-'),

Line 4957: AND tax_rate_code = decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE')

4953: DECODE(to_char(jur.record_type),
4954: '1',jur.state_jurisdiction_code||'0000000',
4955: '3',jur.state_jurisdiction_code||jur.county_jurisdiction_code||'0000',
4956: '6',jur.state_jurisdiction_code||jur.county_jurisdiction_code||LPAD(jur.city_jurisdiction_code,4,'0')))
4957: AND tax_rate_code = decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE')
4958: AND effective_from = decode(greatest(rt.effective_from,G_RECORD_EFFECTIVE_START),rt.effective_from,rt.effective_from,G_RECORD_EFFECTIVE_START)
4959: ) l_count
4960: FROM zx_data_upload_interface rt,
4961: zx_data_upload_interface jur

Line 5082: 'STANDARD',

5078: 1,
5079: TAX,
5080: TAX_REGIME_CODE,
5081: TAX,
5082: 'STANDARD',
5083: NULL,
5084: -99,
5085: 'Y',
5086: decode(greatest(EFFECTIVE_FROM,G_RECORD_EFFECTIVE_START),EFFECTIVE_FROM,EFFECTIVE_FROM,G_RECORD_EFFECTIVE_START),

Line 5303: AND STANDARD_REGIME_CODE = b_regime_code;

5299: ) IS
5300: SELECT NVL(VERSION_LOADED,'0')
5301: FROM ZX_CONTENT_SOURCES
5302: WHERE PROVIDER_ID = b_ptp_id
5303: AND STANDARD_REGIME_CODE = b_regime_code;
5304:
5305: l_migrated_tax_regime_flag VARCHAR2(1);
5306: l_tax_content_source VARCHAR2(80);
5307: l_tax_zone_type VARCHAR2(30);

Line 5697: AND STANDARD_REGIME_CODE = p_tax_regime_code;

5693: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID,
5694: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
5695: PROGRAM_UPDATE_DATE = SYSDATE
5696: WHERE PROVIDER_ID = p_tax_content_source_id
5697: AND STANDARD_REGIME_CODE = p_tax_regime_code;
5698:
5699: IF (SQL%ROWCOUNT = 0)
5700: THEN
5701: INSERT INTO ZX_CONTENT_SOURCES

Line 5707: STANDARD_REGIME_CODE,

5703: PROVIDER_ID,
5704: PROVIDER_REGIME_CODE,
5705: PROVIDER_REGIME_NAME,
5706: LANGUAGE,
5707: STANDARD_REGIME_CODE,
5708: COUNTRY_CODE,
5709: LOADED_FOR_GCO_FLAG,
5710: REGIME_PURPOSE_CODE,
5711: ENTITY_GROUP_CODE,