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_MIGRATE_AR_TAX_DEF dependencies on STANDARD

Line 493: ** 4. Each tax has status named 'STANDARD'.

489: **
490: ** 1. One regime is created for one location structure.
491: ** 2. Segment qualifiers are used to create taxes.
492: ** 3. In addition to that one tax name 'LOCATION' is created for each OU under a regime.
493: ** 4. Each tax has status named 'STANDARD'.
494: ** 5. Rate code is created from AR tax codes with tax type 'LOCATION' for 'LOCATION' tax
495: ** but not for taxes created from segment qualifiers.
496: ** 6. Rates for segument qualifiers taxes is created as part of jurisdiction migration.
497: **

Line 505: ** STATUS CODE : STANDARD

501: ** REGIME CODE : Country Code || '-SALES-TAX-' || location structure id
502: ** REGIME NAME : Country Code || '-SALES-TAX-' || Qualifier1 ||'-'|| Qualifier2..
503: ** TAX (for qualifier) : Location segument qualifiers (ie. CITY, COUNTY..)
504: ** TAX (for location tax code) : 'LOCATION'
505: ** STATUS CODE : STANDARD
506: ** RATE (for location tax code) : Derived from ar_vat_tax_all_b.tax_code
507: **
508: ** i.e.
509: **

Line 511: ** US-SALES-TAX-123 CITY STANDARD NA (zx_migrate_ar_tax_def does not create it)

507: **
508: ** i.e.
509: **
510: ** REGIME TAX STATUS RATES
511: ** US-SALES-TAX-123 CITY STANDARD NA (zx_migrate_ar_tax_def does not create it)
512: ** US-SALES-TAX-123 COUNTY STANDARD NA (zx_migrate_ar_tax_def does not create it)
513: ** US-SALES-TAX-123 STATE STANDARD NA (zx_migrate_ar_tax_def does not create it)
514: ** US-SALES-TAX-123 LOCATION STANDARD Location
515: **

Line 512: ** US-SALES-TAX-123 COUNTY STANDARD NA (zx_migrate_ar_tax_def does not create it)

508: ** i.e.
509: **
510: ** REGIME TAX STATUS RATES
511: ** US-SALES-TAX-123 CITY STANDARD NA (zx_migrate_ar_tax_def does not create it)
512: ** US-SALES-TAX-123 COUNTY STANDARD NA (zx_migrate_ar_tax_def does not create it)
513: ** US-SALES-TAX-123 STATE STANDARD NA (zx_migrate_ar_tax_def does not create it)
514: ** US-SALES-TAX-123 LOCATION STANDARD Location
515: **
516: **

Line 513: ** US-SALES-TAX-123 STATE STANDARD NA (zx_migrate_ar_tax_def does not create it)

509: **
510: ** REGIME TAX STATUS RATES
511: ** US-SALES-TAX-123 CITY STANDARD NA (zx_migrate_ar_tax_def does not create it)
512: ** US-SALES-TAX-123 COUNTY STANDARD NA (zx_migrate_ar_tax_def does not create it)
513: ** US-SALES-TAX-123 STATE STANDARD NA (zx_migrate_ar_tax_def does not create it)
514: ** US-SALES-TAX-123 LOCATION STANDARD Location
515: **
516: **
517: **

Line 514: ** US-SALES-TAX-123 LOCATION STANDARD Location

510: ** REGIME TAX STATUS RATES
511: ** US-SALES-TAX-123 CITY STANDARD NA (zx_migrate_ar_tax_def does not create it)
512: ** US-SALES-TAX-123 COUNTY STANDARD NA (zx_migrate_ar_tax_def does not create it)
513: ** US-SALES-TAX-123 STATE STANDARD NA (zx_migrate_ar_tax_def does not create it)
514: ** US-SALES-TAX-123 LOCATION STANDARD Location
515: **
516: **
517: **
518: ** Cursor loc_str_cur_rec selects as records as follows:

Line 2106: 'STANDARD_TC' L_DEF_TAX_CALC_FORMULA,

2102: 'N' L_HAS_OTHER_JURISDICTIONS_FLAG,
2103: 'Y' L_ALLOW_EXEMPTIONS_FLAG,
2104: 'Y' L_ALLOW_EXCEPTIONS_FLAG,
2105: 'N' L_ALLOW_RECOVERABILITY_FLAG,
2106: 'STANDARD_TC' L_DEF_TAX_CALC_FORMULA,
2107: 'Y' L_TAX_INCLUSIVE_OVERRIDE_FLAG,
2108: 'STANDARD_TB' L_DEF_TAXABLE_BASIS_FORMULA,
2109: 'SHIP_TO_SITE' L_DEF_REGISTR_PARTY_TYPE_CODE,
2110: 'N' L_REGISTRATION_TYPE_RULE_FLAG,

Line 2108: 'STANDARD_TB' L_DEF_TAXABLE_BASIS_FORMULA,

2104: 'Y' L_ALLOW_EXCEPTIONS_FLAG,
2105: 'N' L_ALLOW_RECOVERABILITY_FLAG,
2106: 'STANDARD_TC' L_DEF_TAX_CALC_FORMULA,
2107: 'Y' L_TAX_INCLUSIVE_OVERRIDE_FLAG,
2108: 'STANDARD_TB' L_DEF_TAXABLE_BASIS_FORMULA,
2109: 'SHIP_TO_SITE' L_DEF_REGISTR_PARTY_TYPE_CODE,
2110: 'N' L_REGISTRATION_TYPE_RULE_FLAG,
2111: 'N' L_REPORTING_ONLY_FLAG,
2112: 'N' L_AUTO_PRVN_FLAG,

Line 2521: 'STANDARD_TC' L_DEF_TAX_CALC_FORMULA,

2517: 'N' L_HAS_OTHER_JURISDICTIONS_FLAG,
2518: 'Y' L_ALLOW_EXEMPTIONS_FLAG,
2519: 'Y' L_ALLOW_EXCEPTIONS_FLAG,
2520: 'N' L_ALLOW_RECOVERABILITY_FLAG,
2521: 'STANDARD_TC' L_DEF_TAX_CALC_FORMULA,
2522: 'Y' L_TAX_INCLUSIVE_OVERRIDE_FLAG,
2523: 'STANDARD_TB' L_DEF_TAXABLE_BASIS_FORMULA,
2524: 'SHIP_TO_SITE' L_DEF_REGISTR_PARTY_TYPE_CODE,
2525: 'N' L_REGISTRATION_TYPE_RULE_FLAG,

Line 2523: 'STANDARD_TB' L_DEF_TAXABLE_BASIS_FORMULA,

2519: 'Y' L_ALLOW_EXCEPTIONS_FLAG,
2520: 'N' L_ALLOW_RECOVERABILITY_FLAG,
2521: 'STANDARD_TC' L_DEF_TAX_CALC_FORMULA,
2522: 'Y' L_TAX_INCLUSIVE_OVERRIDE_FLAG,
2523: 'STANDARD_TB' L_DEF_TAXABLE_BASIS_FORMULA,
2524: 'SHIP_TO_SITE' L_DEF_REGISTR_PARTY_TYPE_CODE,
2525: 'N' L_REGISTRATION_TYPE_RULE_FLAG,
2526: 'N' L_REPORTING_ONLY_FLAG,
2527: 'N' L_AUTO_PRVN_FLAG,

Line 2742: 'STANDARD' l_tax_status_code, --TAX_STATUS_CODE

2738: l_last_update_date,
2739: l_last_update_login
2740: )*/
2741: SELECT
2742: 'STANDARD' l_tax_status_code, --TAX_STATUS_CODE
2743: tax.content_owner_id l_content_owner_id, --CONTENT_OWNER_ID
2744: tax.effective_from l_effective_from, --EFFECTIVE_FROM
2745: NULL l_effective_to, --EFFECTIVE_TO
2746: tax.tax l_tax, --TAX

Line 2786: AND status.tax_status_code = 'STANDARD');

2782: FROM zx_status_b status
2783: WHERE tax.tax_regime_code = status.tax_regime_code
2784: AND tax.tax = status.tax
2785: AND tax.content_owner_id = status.content_owner_id --Bug 4563007
2786: AND status.tax_status_code = 'STANDARD');
2787:
2788:
2789: -- ****** Inserting rates for location tax codes ******
2790:

Line 2896: 'STANDARD_TB' , --taxable_basis_formula_code

2892: L_ADJ_FOR_ADHOC_AMT_CODE , --adj_for_adhoc_amt_code
2893: L_ALLOW_ADHOC_TAX_RATE_FLAG , --allow_adhoc_tax_rate_flag
2894: L_TAX_CLASS , --tax_class
2895: NULL , --source_id
2896: 'STANDARD_TB' , --taxable_basis_formula_code
2897: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
2898: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
2899: 'MIGRATED' , --record_type_code
2900: fnd_global.user_id , --created_by

Line 3105: AND status.tax_status_code = 'STANDARD'

3101: zx_party_tax_profile ptp,
3102: ar_system_parameters_all asp
3103: WHERE status.tax_regime_code like '%-SALES-TAX-%'
3104: AND status.tax = 'LOCATION'
3105: AND status.tax_status_code = 'STANDARD'
3106: AND status.content_owner_id = ptp.party_tax_profile_id
3107: AND ptp.party_type_code = 'OU'
3108: -- YK:02/22/2005
3109: AND ptp.party_id = codes.org_id

Line 3231: 'STANDARD_TB' , --taxable_basis_formula_code

3227: L_ADJ_FOR_ADHOC_AMT_CODE , --adj_for_adhoc_amt_code
3228: L_ALLOW_ADHOC_TAX_RATE_FLAG , --allow_adhoc_tax_rate_flag
3229: L_TAX_CLASS , --tax_class
3230: NULL , --source_id
3231: 'STANDARD_TB' , --taxable_basis_formula_code
3232: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
3233: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
3234: 'MIGRATED' , --record_type_code
3235: fnd_global.user_id , --created_by

Line 3440: AND status.tax_status_code = 'STANDARD'

3436: zx_party_tax_profile ptp,
3437: ar_system_parameters_all asp
3438: WHERE status.tax_regime_code like '%-SALES-TAX-%'
3439: AND status.tax = 'LOCATION'
3440: AND status.tax_status_code = 'STANDARD'
3441: AND status.content_owner_id = ptp.party_tax_profile_id
3442: AND ptp.party_type_code = 'OU'
3443: -- YK:02/22/2005
3444: AND ptp.party_id = codes.org_id

Line 3472: 'STANDARD', --Status

3468:
3469: FOR rec in loc_rate_csr LOOP
3470: insert_tax_rate_code (rec.tax_regime_code,
3471: rec.tax,
3472: 'STANDARD', --Status
3473: rec.tax, --Rate
3474: rec.party_tax_profile_id, --Content Owner ID
3475: rec.org_id, --Org ID
3476: 'Y', --Active Flag

Line 3525: | Status Code : STANDARD

Line 3556: | Status Code : STANDARD

3552: |
3553: | Set live_for_processing_flag to 'Y' for these taxes
3554: | Set live_for_applicability_flag to 'N' for these taxes
3555: |
3556: | Status Code : STANDARD
3557: |
3558: | Rate Code : STATE, COUNTY, CITY tax rate codes for taxes
3559: | created during migration. They're owned by each content owner.
3560: |

Line 4035: 'STANDARD' l_tax_status_code, --TAX_STATUS_CODE

4031: l_request_id,
4032: 1
4033: )
4034: SELECT
4035: 'STANDARD' l_tax_status_code, --TAX_STATUS_CODE
4036: ztb.content_owner_id l_content_owner_id, --CONTENT_OWNER_ID
4037: ztb.effective_from l_effective_from, --EFFECTIVE_FROM
4038: NULL l_effective_to, --EFFECTIVE_TO
4039: ztb.tax l_tax, --TAX

Line 4079: AND zsb.tax_status_code = 'STANDARD');

4075: FROM zx_status_b zsb
4076: WHERE zsb.tax_regime_code = ztb.tax_regime_code
4077: AND zsb.tax = ztb.tax
4078: AND zsb.content_owner_id = ztb.content_owner_id
4079: AND zsb.tax_status_code = 'STANDARD');
4080:
4081: --
4082: -- Populate Rates : Taxware and Vertex : Phase I
4083: --

Line 4195: 'STANDARD_TB' , --taxable_basis_formula_code

4191: L_ADJ_FOR_ADHOC_AMT_CODE , --adj_for_adhoc_amt_code
4192: L_ALLOW_ADHOC_TAX_RATE_FLAG , --allow_adhoc_tax_rate_flag
4193: L_TAX_CLASS , --tax_class
4194: NULL , --source_id
4195: 'STANDARD_TB' , --taxable_basis_formula_code
4196: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
4197: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
4198: 'MIGRATED' , --record_type_code
4199: fnd_global.user_id , --created_by

Line 4330: 'STANDARD' L_TAX_STATUS_CODE,

4326: avt.start_date L_EFFECTIVE_FROM,
4327: avt.end_date L_EFFECTIVE_TO,
4328: zrb.tax_regime_code L_TAX_REGIME_CODE ,
4329: ztb.tax L_TAX,
4330: 'STANDARD' L_TAX_STATUS_CODE,
4331: 'N' L_SCHEDULE_BASED_RATE_FLAG,
4332: 'PERCENTAGE' L_RATE_TYPE_CODE,
4333: avt.tax_rate L_PERCENTAGE_RATE,
4334: NULL L_QUANTITY_RATE,

Line 4527: 'STANDARD_TB' , --taxable_basis_formula_code

4523: L_ADJ_FOR_ADHOC_AMT_CODE , --adj_for_adhoc_amt_code
4524: L_ALLOW_ADHOC_TAX_RATE_FLAG , --allow_adhoc_tax_rate_flag
4525: L_TAX_CLASS , --tax_class
4526: NULL , --source_id
4527: 'STANDARD_TB' , --taxable_basis_formula_code
4528: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
4529: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
4530: 'MIGRATED' , --record_type_code
4531: fnd_global.user_id , --created_by

Line 4662: 'STANDARD' L_TAX_STATUS_CODE,

4658: avt.start_date L_EFFECTIVE_FROM,
4659: avt.end_date L_EFFECTIVE_TO,
4660: zrb.tax_regime_code L_TAX_REGIME_CODE ,
4661: ztb.tax L_TAX,
4662: 'STANDARD' L_TAX_STATUS_CODE,
4663: 'N' L_SCHEDULE_BASED_RATE_FLAG,
4664: 'PERCENTAGE' L_RATE_TYPE_CODE,
4665: avt.tax_rate L_PERCENTAGE_RATE,
4666: NULL L_QUANTITY_RATE,

Line 4822: -- 'STANDARD', --Status

4818: -- FOR k IN 1..content_owner_id_rec.count LOOP
4819: -- Create STATE tax rate code
4820: -- insert_tax_rate_code ('US-SALES-TAX-'|| TO_CHAR(location_structure_id_rec(k)), --Regime
4821: -- 'STATE', --Tax
4822: -- 'STANDARD', --Status
4823: -- 'STATE', --Rate
4824: -- content_owner_id_rec(k), --Content Owner ID
4825: -- org_id_rec(k), --Org ID
4826: -- 'Y', --Active Flag

Line 4835: -- 'STANDARD', --Status

4831: -- );
4832: -- COUNTY tax rate code
4833: -- insert_tax_rate_code ('US-SALES-TAX-'|| TO_CHAR(location_structure_id_rec(k)), --Regime
4834: -- 'COUNTY', --Tax
4835: -- 'STANDARD', --Status
4836: -- 'COUNTY', --Rate
4837: -- content_owner_id_rec(k), --Content Owner ID
4838: -- org_id_rec(k), --Org ID
4839: -- 'Y', --Active Flag

Line 4848: -- 'STANDARD', --Status

4844: -- );
4845: -- CITY tax rate code
4846: -- insert_tax_rate_code ('US-SALES-TAX-'|| TO_CHAR(location_structure_id_rec(k)), --Regime
4847: -- 'CITY', --Tax
4848: -- 'STANDARD', --Status
4849: -- 'CITY', --Rate
4850: -- content_owner_id_rec(k), --Content Owner ID
4851: -- org_id_rec(k), --Org ID
4852: -- 'Y', --Active Flag

Line 4866: 'STANDARD', --Status

4862:
4863: FOR rec in loc_rate_csr LOOP
4864: insert_tax_rate_code (rec.tax_regime_code,
4865: rec.tax,
4866: 'STANDARD', --Status
4867: rec.tax, --Rate
4868: rec.party_tax_profile_id, --Content Owner ID
4869: rec.org_id, --Org ID
4870: 'Y', --Active Flag

Line 5237: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT'

5233: 'Y', 'TAX_RATE',
5234: 'N', NULL) ADJ_FOR_ADHOC_AMT_CODE,
5235: codes.validate_flag ALLOW_ADHOC_TAX_RATE_FLAG,
5236: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
5237: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT'
5238: , 'QUANTITY' , 'STANDARD_QUANTITY'
5239: , 'STANDARD_TB') L_TAXABLE_BASIS_FORMULA,
5240: codes.DESCRIPTION DESCRIPTION ,-- Bug 4705196
5241: nvl(asp.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') ALLOW_EXEMPTIONS_FLAG,

Line 5238: , 'QUANTITY' , 'STANDARD_QUANTITY'

5234: 'N', NULL) ADJ_FOR_ADHOC_AMT_CODE,
5235: codes.validate_flag ALLOW_ADHOC_TAX_RATE_FLAG,
5236: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
5237: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT'
5238: , 'QUANTITY' , 'STANDARD_QUANTITY'
5239: , 'STANDARD_TB') L_TAXABLE_BASIS_FORMULA,
5240: codes.DESCRIPTION DESCRIPTION ,-- Bug 4705196
5241: nvl(asp.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') ALLOW_EXEMPTIONS_FLAG,
5242: 'N' ALLOW_EXCEPTIONS_FLAG --Bug 5505935

Line 5239: , 'STANDARD_TB') L_TAXABLE_BASIS_FORMULA,

5235: codes.validate_flag ALLOW_ADHOC_TAX_RATE_FLAG,
5236: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
5237: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT'
5238: , 'QUANTITY' , 'STANDARD_QUANTITY'
5239: , 'STANDARD_TB') L_TAXABLE_BASIS_FORMULA,
5240: codes.DESCRIPTION DESCRIPTION ,-- Bug 4705196
5241: nvl(asp.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') ALLOW_EXEMPTIONS_FLAG,
5242: 'N' ALLOW_EXCEPTIONS_FLAG --Bug 5505935
5243: FROM

Line 5592: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT'

5588: 'Y', 'TAX_RATE',
5589: 'N', NULL) ADJ_FOR_ADHOC_AMT_CODE,
5590: codes.validate_flag ALLOW_ADHOC_TAX_RATE_FLAG,
5591: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
5592: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT'
5593: , 'QUANTITY' , 'STANDARD_QUANTITY'
5594: , 'STANDARD_TB') L_TAXABLE_BASIS_FORMULA,
5595: codes.DESCRIPTION DESCRIPTION ,-- Bug 4705196
5596: nvl(asp.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') ALLOW_EXEMPTIONS_FLAG,

Line 5593: , 'QUANTITY' , 'STANDARD_QUANTITY'

5589: 'N', NULL) ADJ_FOR_ADHOC_AMT_CODE,
5590: codes.validate_flag ALLOW_ADHOC_TAX_RATE_FLAG,
5591: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
5592: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT'
5593: , 'QUANTITY' , 'STANDARD_QUANTITY'
5594: , 'STANDARD_TB') L_TAXABLE_BASIS_FORMULA,
5595: codes.DESCRIPTION DESCRIPTION ,-- Bug 4705196
5596: nvl(asp.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') ALLOW_EXEMPTIONS_FLAG,
5597: 'N' ALLOW_EXCEPTIONS_FLAG --Bug 5505935

Line 5594: , 'STANDARD_TB') L_TAXABLE_BASIS_FORMULA,

5590: codes.validate_flag ALLOW_ADHOC_TAX_RATE_FLAG,
5591: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
5592: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT'
5593: , 'QUANTITY' , 'STANDARD_QUANTITY'
5594: , 'STANDARD_TB') L_TAXABLE_BASIS_FORMULA,
5595: codes.DESCRIPTION DESCRIPTION ,-- Bug 4705196
5596: nvl(asp.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') ALLOW_EXEMPTIONS_FLAG,
5597: 'N' ALLOW_EXCEPTIONS_FLAG --Bug 5505935
5598: FROM

Line 5879: 'O', 'STANDARD',

5875: codes.end_date EFFECTIVE_TO,
5876: params.global_attribute13 TAX_REGIME_CODE ,
5877: codes.global_attribute1 TAX,
5878: DECODE(codes.tax_class,
5879: 'O', 'STANDARD',
5880: 'I', 'STANDARD_AR_INPUT',
5881: 'STANDARD') TAX_STATUS_CODE,
5882: 'N' SCHEDULE_BASED_RATE_FLAG,
5883: 'PERCENTAGE' RATE_TYPE_CODE,

Line 5880: 'I', 'STANDARD_AR_INPUT',

5876: params.global_attribute13 TAX_REGIME_CODE ,
5877: codes.global_attribute1 TAX,
5878: DECODE(codes.tax_class,
5879: 'O', 'STANDARD',
5880: 'I', 'STANDARD_AR_INPUT',
5881: 'STANDARD') TAX_STATUS_CODE,
5882: 'N' SCHEDULE_BASED_RATE_FLAG,
5883: 'PERCENTAGE' RATE_TYPE_CODE,
5884: codes.tax_rate PERCENTAGE_RATE,

Line 5881: 'STANDARD') TAX_STATUS_CODE,

5877: codes.global_attribute1 TAX,
5878: DECODE(codes.tax_class,
5879: 'O', 'STANDARD',
5880: 'I', 'STANDARD_AR_INPUT',
5881: 'STANDARD') TAX_STATUS_CODE,
5882: 'N' SCHEDULE_BASED_RATE_FLAG,
5883: 'PERCENTAGE' RATE_TYPE_CODE,
5884: codes.tax_rate PERCENTAGE_RATE,
5885: NULL QUANTITY_RATE ,

Line 5948: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT','STANDARD_TB') L_TAXABLE_BASIS_FORMULA,

5944: 'Y', 'TAX_RATE',
5945: 'N', NULL) ADJ_FOR_ADHOC_AMT_CODE,
5946: codes.validate_flag ALLOW_ADHOC_TAX_RATE_FLAG,
5947: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
5948: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT','STANDARD_TB') L_TAXABLE_BASIS_FORMULA,
5949: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
5950: FROM
5951: ar_vat_tax_all_b codes,
5952: zx_party_tax_profile ptp,

Line 6441: 'STANDARD_TC' , -- DEF_TAX_CALC_FORMULA

6437: -- Bug 4432896 : Set allow_exemptions_flag to 'Y'
6438: 'Y' , -- ALLOW_EXEMPTIONS_FLAG
6439: 'Y' , -- ALLOW_EXCEPTIONS_FLAG
6440: 'N' , -- ALLOW_RECOVERABILITY_FLAG
6441: 'STANDARD_TC' , -- DEF_TAX_CALC_FORMULA
6442: 'N' , -- TAX_INCLUSIVE_OVERRIDE_FLAG
6443: 'STANDARD_TB' , -- DEF_TAXABLE_BASIS_FORMULA
6444: 'SHIP_TO_SITE' , -- DEF_REGISTR_PARTY_TYPE_CODE
6445: 'N' , -- REGISTRATION_TYPE_RULE_FLAG

Line 6443: 'STANDARD_TB' , -- DEF_TAXABLE_BASIS_FORMULA

6439: 'Y' , -- ALLOW_EXCEPTIONS_FLAG
6440: 'N' , -- ALLOW_RECOVERABILITY_FLAG
6441: 'STANDARD_TC' , -- DEF_TAX_CALC_FORMULA
6442: 'N' , -- TAX_INCLUSIVE_OVERRIDE_FLAG
6443: 'STANDARD_TB' , -- DEF_TAXABLE_BASIS_FORMULA
6444: 'SHIP_TO_SITE' , -- DEF_REGISTR_PARTY_TYPE_CODE
6445: 'N' , -- REGISTRATION_TYPE_RULE_FLAG
6446: 'N' , -- REPORTING_ONLY_FLAG
6447: 'N' , -- AUTO_PRVN_FLAG

Line 7567: 'STANDARD_TC' ,--DEF_TAX_CALC_FORMULA

7563: 'N' ,--HAS_OTHER_JURISDICTIONS_FLAG
7564: ALLOW_EXEMPTIONS_FLAG ,--ALLOW_EXEMPTIONS_FLAG
7565: ALLOW_EXCEPTIONS_FLAG ,--ALLOW_EXCEPTIONS_FLAG
7566: 'N' ,--ALLOW_RECOVERABILITY_FLAG
7567: 'STANDARD_TC' ,--DEF_TAX_CALC_FORMULA
7568: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG --YK: 8/30/2004: Must be 'Y' as rate can be either 'Y' or 'N'.
7569: 'STANDARD_TB' ,--DEF_TAXABLE_BASIS_FORMULA --YK: 8/30/2004: Compounding
7570: 'SHIP_TO_SITE' ,--DEF_REGISTR_PARTY_TYPE_CODE
7571: 'N' ,--REGISTRATION_TYPE_RULE_FLAG

Line 7569: 'STANDARD_TB' ,--DEF_TAXABLE_BASIS_FORMULA --YK: 8/30/2004: Compounding

7565: ALLOW_EXCEPTIONS_FLAG ,--ALLOW_EXCEPTIONS_FLAG
7566: 'N' ,--ALLOW_RECOVERABILITY_FLAG
7567: 'STANDARD_TC' ,--DEF_TAX_CALC_FORMULA
7568: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG --YK: 8/30/2004: Must be 'Y' as rate can be either 'Y' or 'N'.
7569: 'STANDARD_TB' ,--DEF_TAXABLE_BASIS_FORMULA --YK: 8/30/2004: Compounding
7570: 'SHIP_TO_SITE' ,--DEF_REGISTR_PARTY_TYPE_CODE
7571: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
7572: 'N' ,--REPORTING_ONLY_FLAG
7573: 'N' ,--AUTO_PRVN_FLAG

Line 7920: 'STANDARD_TC' ,--DEF_TAX_CALC_FORMULA

7916: 'N' ,--HAS_OTHER_JURISDICTIONS_FLAG
7917: ALLOW_EXEMPTIONS_FLAG ,--ALLOW_EXEMPTIONS_FLAG
7918: ALLOW_EXCEPTIONS_FLAG ,--ALLOW_EXCEPTIONS_FLAG
7919: 'N' ,--ALLOW_RECOVERABILITY_FLAG
7920: 'STANDARD_TC' ,--DEF_TAX_CALC_FORMULA
7921: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG --YK: 8/30/2004: Must be 'Y' as rate can be either 'Y' or 'N'.
7922: 'STANDARD_TB' ,--DEF_TAXABLE_BASIS_FORMULA --YK: 8/30/2004: Compounding
7923: 'SHIP_TO_SITE' ,--DEF_REGISTR_PARTY_TYPE_CODE
7924: 'N' ,--REGISTRATION_TYPE_RULE_FLAG

Line 7922: 'STANDARD_TB' ,--DEF_TAXABLE_BASIS_FORMULA --YK: 8/30/2004: Compounding

7918: ALLOW_EXCEPTIONS_FLAG ,--ALLOW_EXCEPTIONS_FLAG
7919: 'N' ,--ALLOW_RECOVERABILITY_FLAG
7920: 'STANDARD_TC' ,--DEF_TAX_CALC_FORMULA
7921: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG --YK: 8/30/2004: Must be 'Y' as rate can be either 'Y' or 'N'.
7922: 'STANDARD_TB' ,--DEF_TAXABLE_BASIS_FORMULA --YK: 8/30/2004: Compounding
7923: 'SHIP_TO_SITE' ,--DEF_REGISTR_PARTY_TYPE_CODE
7924: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
7925: 'N' ,--REPORTING_ONLY_FLAG
7926: 'N' ,--AUTO_PRVN_FLAG

Line 10083: 'STANDARD_TB' , --taxable_basis_formula_code

10079: 'TAX_RATE' , --adj_for_adhoc_amt_code
10080: 'Y' , --allow_adhoc_tax_rate_flag
10081: 'OUTPUT' , --tax_class
10082: NULL , --source_id
10083: 'STANDARD_TB' , --taxable_basis_formula_code
10084: 'N' , --inclusive_tax_flag
10085: 'N' , --tax_inclusive_override_flag
10086: 'MIGRATED' , --record_type_code
10087: fnd_global.user_id , --created_by