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 395: OPEN c_tax_status_exists(p_tax_regime_code,l_tax,-99,'STANDARD');

391:
392: END IF;
393:
394: l_exists_flag := 'N';
395: OPEN c_tax_status_exists(p_tax_regime_code,l_tax,-99,'STANDARD');
396: FETCH c_tax_status_exists
397: INTO l_exists_flag;
398: CLOSE c_tax_status_exists;
399:

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

402:
403: FND_FILE.PUT_LINE
404: (
405: FND_FILE.LOG,
406: 'Creating STANDARD Tax Status for Tax: '||l_tax||'.'
407: );
408:
409: INSERT INTO ZX_STATUS_B_TMP
410: (

Line 454: 'STANDARD', --TAX_STATUS_CODE

450: )
451: VALUES
452: (
453: ZX_STATUS_B_S.NEXTVAL, --TAX_STATUS_ID
454: 'STANDARD', --TAX_STATUS_CODE
455: -99, --CONTENT_OWNER_ID
456: G_RECORD_EFFECTIVE_START,--EFFECTIVE_FROM
457: NULL, --EFFECTIVE_TO
458: l_tax, --TAX

Line 521: 'STANDARD' ,

517: )
518: SELECT
519: fl.LANGUAGE_CODE ,
520: USERENV('LANG') ,
521: 'STANDARD' ,
522: fnd_global.user_id , -- CREATED_BY
523: SYSDATE , -- CREATION_DATE
524: fnd_global.user_id , -- LAST_UPDATED_BY
525: SYSDATE , -- LAST_UPDATE_DATE

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

530: WHERE fl.INSTALLED_FLAG IN ('I', 'B')
531: AND zsb.TAX_REGIME_CODE = p_tax_regime_code
532: AND zsb.CONTENT_OWNER_ID = -99
533: AND zsb.TAX = l_tax
534: AND zsb.TAX_STATUS_CODE = 'STANDARD';
535:
536: FND_FILE.PUT_LINE
537: (
538: FND_FILE.LOG,

Line 1622: 'STANDARD' tax_status_code,

1618: state_jurisdiction_code,
1619: p_tax_regime_code tax_regime_code,
1620: 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,
1621: -99 content_owner_id,
1622: 'STANDARD' tax_status_code,
1623: decode(p_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,
1624: effective_from,
1625: effective_to,
1626: 'PERCENTAGE' rate_type_code,

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

1619: p_tax_regime_code tax_regime_code,
1620: 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,
1621: -99 content_owner_id,
1622: 'STANDARD' tax_status_code,
1623: decode(p_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,
1624: effective_from,
1625: effective_to,
1626: 'PERCENTAGE' rate_type_code,
1627: decode(record_type,9,sales_tax_rate,10,rental_tax_rate,11,use_tax_rate,12,lease_tax_rate) percentage_rate,

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

1720: county_jurisdiction_code,
1721: state_jurisdiction_code,
1722: 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,
1723: -99 content_owner_id,
1724: decode(p_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,
1725: effective_from,
1726: 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
1727: FROM zx_data_upload_interface
1728: WHERE record_type in (9,10,11,12)

Line 2375: 'STANDARD_NAME',

2371: VALUES
2372: (
2373: geography_id,
2374: p_tax_content_source,
2375: 'STANDARD_NAME',
2376: geography_name,
2377: 1,
2378: 'NAME',
2379: 'Y',

Line 2461: 'STANDARD_NAME',

2457: VALUES
2458: (
2459: geography_id,
2460: p_tax_content_source,
2461: 'STANDARD_NAME',
2462: geography_name1,
2463: 1,
2464: 'NAME',
2465: 'N',

Line 2500: 'STANDARD_NAME',

2496: VALUES
2497: (
2498: geography_id,
2499: p_tax_content_source,
2500: 'STANDARD_NAME',
2501: geography_name,
2502: 1,
2503: 'NAME',
2504: 'N',

Line 2577: 'STANDARD_NAME',

2573: VALUES
2574: (
2575: geography_id,
2576: p_tax_content_source,
2577: 'STANDARD_NAME',
2578: geography_name1,
2579: 1,
2580: 'NAME',
2581: 'N',

Line 2931: AND hgi.identifier_subtype = 'STANDARD_NAME'

2927: 'EXISTS' = (SELECT 'EXISTS'
2928: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi
2929: WHERE hgi.geography_id = v.geography_id
2930: AND hgi.identifier_type = 'NAME'
2931: AND hgi.identifier_subtype = 'STANDARD_NAME'
2932: AND UPPER(hgi.identifier_value) = UPPER(DECODE(geography_type,'STATE',geography_name1,geography_name)))
2933: THEN 'NOCHANGE'
2934: WHEN status = 'UPDATE'
2935: THEN 'UPDATE'

Line 3260: 'STANDARD_NAME',

3256: VALUES
3257: (
3258: zone_geography_id,
3259: p_tax_content_source,
3260: 'STANDARD_NAME',
3261: geo_code,
3262: 1,
3263: 'NAME',
3264: 'Y',

Line 4308: 'STANDARD_NAME',

4304: VALUES
4305: (
4306: hz_geographies_s.nextval,
4307: p_tax_content_source,
4308: 'STANDARD_NAME',
4309: geography_name,
4310: 1,
4311: 'NAME',
4312: 'Y',

Line 4939: 'STANDARD_NAME',

4935: VALUES
4936: (
4937: geography_id,
4938: p_tax_content_source,
4939: 'STANDARD_NAME',
4940: geography_name,
4941: 1,
4942: 'NAME',
4943: 'N',

Line 4965: AND hgi.IDENTIFIER_SUBTYPE = 'STANDARD_NAME'

4961: AND NOT EXISTS (SELECT 1
4962: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi
4963: WHERE hgi.geography_id = inter.geography_id
4964: AND hgi.IDENTIFIER_TYPE = 'NAME'
4965: AND hgi.IDENTIFIER_SUBTYPE = 'STANDARD_NAME'
4966: AND UPPER(hgi.IDENTIFIER_VALUE) = UPPER(inter.geography_name)
4967: AND hgi.LANGUAGE_CODE = 'US');
4968:
4969: FND_FILE.PUT_LINE

Line 5109: 'STANDARD' tax_status_code,

5105: (SELECT DISTINCT
5106: p_tax_regime_code tax_regime_code,
5107: 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,
5108: -99 content_owner_id,
5109: 'STANDARD' tax_status_code,
5110: 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),
5111: 'STATE',decode(to_char(jur.record_type),'1','ST-','3','ST-CO-','6','ST-CI-'),
5112: 'COUNTY',decode(to_char(jur.record_type),'3','CO-','6','CO-CI-'),
5113: 'CITY','CI-')||

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

5128: '1',jur.state_jurisdiction_code||'0000000',
5129: '3',jur.state_jurisdiction_code||jur.county_jurisdiction_code||'0000',
5130: '6',jur.state_jurisdiction_code||jur.county_jurisdiction_code||TRIM(SUBSTR(jur.city_jurisdiction_code,1,19)))
5131: ) tax_jurisdiction_code,
5132: decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,
5133: decode(greatest(rt.effective_from,G_RECORD_EFFECTIVE_START),rt.effective_from,rt.effective_from,G_RECORD_EFFECTIVE_START) effective_from,
5134: rt.effective_to,
5135: 'PERCENTAGE' rate_type_code,
5136: 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 5144: 'STANDARD' ,

5140: OVER (PARTITION BY
5141: p_tax_regime_code,
5142: 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) ,
5143: -99 ,
5144: 'STANDARD' ,
5145: 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),
5146: 'STATE',decode(to_char(jur.record_type),'1','ST-','3','ST-CO-','6','ST-CI-'),
5147: 'COUNTY',decode(to_char(jur.record_type),'3','CO-','6','CO-CI-'),
5148: 'CITY','CI-')||

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

5163: '1',jur.state_jurisdiction_code||'0000000',
5164: '3',jur.state_jurisdiction_code||jur.county_jurisdiction_code||'0000',
5165: '6',jur.state_jurisdiction_code||jur.county_jurisdiction_code||TRIM(SUBSTR(jur.city_jurisdiction_code,1,19)))
5166: ) ,
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

Line 5174: AND tax_status_code = 'STANDARD'

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
5176: 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),
5177: 'STATE',decode(to_char(jur.record_type),'1','ST-','3','ST-CO-','6','ST-CI-'),
5178: 'COUNTY',decode(to_char(jur.record_type),'3','CO-','6','CO-CI-'),

Line 5197: 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')

5193: DECODE(to_char(jur.record_type),
5194: '1',jur.state_jurisdiction_code||'0000000',
5195: '3',jur.state_jurisdiction_code||jur.county_jurisdiction_code||'0000',
5196: '6',jur.state_jurisdiction_code||jur.county_jurisdiction_code||TRIM(SUBSTR(jur.city_jurisdiction_code,1,19))))
5197: 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')
5198: AND effective_from = decode(greatest(rt.effective_from,G_RECORD_EFFECTIVE_START),rt.effective_from,rt.effective_from,G_RECORD_EFFECTIVE_START)
5199: ) l_count
5200: FROM zx_data_upload_interface rt,
5201: zx_data_upload_interface jur

Line 5321: 'STANDARD' tax_status_code,

5317: (SELECT DISTINCT
5318: p_tax_regime_code tax_regime_code,
5319: 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,
5320: -99 content_owner_id,
5321: 'STANDARD' tax_status_code,
5322: 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),
5323: 'STATE',decode(to_char(jur.record_type),'1','ST-','3','ST-CO-','6','ST-CI-'),
5324: 'COUNTY',decode(to_char(jur.record_type),'3','CO-','6','CO-CI-'),
5325: 'CITY','CI-')||

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

5340: '1',jur.state_jurisdiction_code||'0000000',
5341: '3',jur.state_jurisdiction_code||jur.county_jurisdiction_code||'0000',
5342: '6',jur.state_jurisdiction_code||jur.county_jurisdiction_code||TRIM(SUBSTR(jur.city_jurisdiction_code,1,19)))
5343: ) tax_jurisdiction_code,
5344: decode(l_migrated_tax_regime_flag,'Y','STANDARD','STD')||decode(to_char(rt.record_type),'10','-RENTAL','11','-USE','12','-LEASE') tax_rate_code,
5345: decode(greatest(rt.effective_from,G_RECORD_EFFECTIVE_START),rt.effective_from,rt.effective_from,G_RECORD_EFFECTIVE_START) effective_from,
5346: rt.effective_to,
5347: 'PERCENTAGE' rate_type_code,
5348: 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 5356: 'STANDARD' ,

5352: OVER (PARTITION BY
5353: p_tax_regime_code,
5354: 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) ,
5355: -99 ,
5356: 'STANDARD' ,
5357: 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),
5358: 'STATE',decode(to_char(jur.record_type),'1','ST-','3','ST-CO-','6','ST-CI-'),
5359: 'COUNTY',decode(to_char(jur.record_type),'3','CO-','6','CO-CI-'),
5360: 'CITY','CI-')||

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

5375: '1',jur.state_jurisdiction_code||'0000000',
5376: '3',jur.state_jurisdiction_code||jur.county_jurisdiction_code||'0000',
5377: '6',jur.state_jurisdiction_code||jur.county_jurisdiction_code||TRIM(SUBSTR(jur.city_jurisdiction_code,1,19)))
5378: ) ,
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

Line 5386: AND tax_status_code = 'STANDARD'

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
5388: 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),
5389: 'STATE',decode(to_char(jur.record_type),'1','ST-','3','ST-CO-','6','ST-CI-'),
5390: 'COUNTY',decode(to_char(jur.record_type),'3','CO-','6','CO-CI-'),

Line 5409: 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')

5405: DECODE(to_char(jur.record_type),
5406: '1',jur.state_jurisdiction_code||'0000000',
5407: '3',jur.state_jurisdiction_code||jur.county_jurisdiction_code||'0000',
5408: '6',jur.state_jurisdiction_code||jur.county_jurisdiction_code||TRIM(SUBSTR(jur.city_jurisdiction_code,1,19))))
5409: 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')
5410: AND effective_from = decode(greatest(rt.effective_from,G_RECORD_EFFECTIVE_START),rt.effective_from,rt.effective_from,G_RECORD_EFFECTIVE_START)
5411: ) l_count
5412: FROM zx_data_upload_interface rt,
5413: zx_data_upload_interface jur

Line 5548: 'STANDARD',

5544: 1,
5545: TAX,
5546: TAX_REGIME_CODE,
5547: TAX,
5548: 'STANDARD',
5549: NULL,
5550: -99,
5551: 'Y',
5552: decode(greatest(EFFECTIVE_FROM,G_RECORD_EFFECTIVE_START),EFFECTIVE_FROM,EFFECTIVE_FROM,G_RECORD_EFFECTIVE_START),

Line 5802: AND STANDARD_REGIME_CODE = b_regime_code;

5798: ) IS
5799: SELECT NVL(VERSION_LOADED,'0')
5800: FROM ZX_CONTENT_SOURCES
5801: WHERE PROVIDER_ID = b_ptp_id
5802: AND STANDARD_REGIME_CODE = b_regime_code;
5803:
5804: CURSOR c_chk_ptp_party
5805: (
5806: b_ptp_id NUMBER

Line 6223: AND STANDARD_REGIME_CODE = p_tax_regime_code;

6219: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID,
6220: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
6221: PROGRAM_UPDATE_DATE = SYSDATE
6222: WHERE PROVIDER_ID = p_tax_content_source_id
6223: AND STANDARD_REGIME_CODE = p_tax_regime_code;
6224:
6225: IF (SQL%ROWCOUNT = 0)
6226: THEN
6227: INSERT INTO ZX_CONTENT_SOURCES

Line 6233: STANDARD_REGIME_CODE,

6229: PROVIDER_ID,
6230: PROVIDER_REGIME_CODE,
6231: PROVIDER_REGIME_NAME,
6232: LANGUAGE,
6233: STANDARD_REGIME_CODE,
6234: COUNTRY_CODE,
6235: LOADED_FOR_GCO_FLAG,
6236: REGIME_PURPOSE_CODE,
6237: ENTITY_GROUP_CODE,