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 475: ** 4. Each tax has status named 'STANDARD'.

471: **
472: ** 1. One regime is created for one location structure.
473: ** 2. Segment qualifiers are used to create taxes.
474: ** 3. In addition to that one tax name 'LOCATION' is created for each OU under a regime.
475: ** 4. Each tax has status named 'STANDARD'.
476: ** 5. Rate code is created from AR tax codes with tax type 'LOCATION' for 'LOCATION' tax
477: ** but not for taxes created from segment qualifiers.
478: ** 6. Rates for segument qualifiers taxes is created as part of jurisdiction migration.
479: **

Line 487: ** STATUS CODE : STANDARD

483: ** REGIME CODE : Country Code || '-SALES-TAX-' || location structure id
484: ** REGIME NAME : Country Code || '-SALES-TAX-' || Qualifier1 ||'-'|| Qualifier2..
485: ** TAX (for qualifier) : Location segument qualifiers (ie. CITY, COUNTY..)
486: ** TAX (for location tax code) : 'LOCATION'
487: ** STATUS CODE : STANDARD
488: ** RATE (for location tax code) : Derived from ar_vat_tax_all_b.tax_code
489: **
490: ** i.e.
491: **

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

489: **
490: ** i.e.
491: **
492: ** REGIME TAX STATUS RATES
493: ** US-SALES-TAX-123 CITY STANDARD NA (zx_migrate_ar_tax_def does not create it)
494: ** US-SALES-TAX-123 COUNTY STANDARD NA (zx_migrate_ar_tax_def does not create it)
495: ** US-SALES-TAX-123 STATE STANDARD NA (zx_migrate_ar_tax_def does not create it)
496: ** US-SALES-TAX-123 LOCATION STANDARD Location
497: **

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

490: ** i.e.
491: **
492: ** REGIME TAX STATUS RATES
493: ** US-SALES-TAX-123 CITY STANDARD NA (zx_migrate_ar_tax_def does not create it)
494: ** US-SALES-TAX-123 COUNTY STANDARD NA (zx_migrate_ar_tax_def does not create it)
495: ** US-SALES-TAX-123 STATE STANDARD NA (zx_migrate_ar_tax_def does not create it)
496: ** US-SALES-TAX-123 LOCATION STANDARD Location
497: **
498: **

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

491: **
492: ** REGIME TAX STATUS RATES
493: ** US-SALES-TAX-123 CITY STANDARD NA (zx_migrate_ar_tax_def does not create it)
494: ** US-SALES-TAX-123 COUNTY STANDARD NA (zx_migrate_ar_tax_def does not create it)
495: ** US-SALES-TAX-123 STATE STANDARD NA (zx_migrate_ar_tax_def does not create it)
496: ** US-SALES-TAX-123 LOCATION STANDARD Location
497: **
498: **
499: **

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

492: ** REGIME TAX STATUS RATES
493: ** US-SALES-TAX-123 CITY STANDARD NA (zx_migrate_ar_tax_def does not create it)
494: ** US-SALES-TAX-123 COUNTY STANDARD NA (zx_migrate_ar_tax_def does not create it)
495: ** US-SALES-TAX-123 STATE STANDARD NA (zx_migrate_ar_tax_def does not create it)
496: ** US-SALES-TAX-123 LOCATION STANDARD Location
497: **
498: **
499: **
500: ** Cursor loc_str_cur_rec selects as records as follows:

Line 2020: 'STANDARD_TC' L_DEF_TAX_CALC_FORMULA,

2016: 'N' L_HAS_OTHER_JURISDICTIONS_FLAG,
2017: 'Y' L_ALLOW_EXEMPTIONS_FLAG,
2018: 'Y' L_ALLOW_EXCEPTIONS_FLAG,
2019: 'N' L_ALLOW_RECOVERABILITY_FLAG,
2020: 'STANDARD_TC' L_DEF_TAX_CALC_FORMULA,
2021: 'Y' L_TAX_INCLUSIVE_OVERRIDE_FLAG,
2022: 'STANDARD_TB' L_DEF_TAXABLE_BASIS_FORMULA,
2023: 'SHIP_TO_SITE' L_DEF_REGISTR_PARTY_TYPE_CODE,
2024: 'N' L_REGISTRATION_TYPE_RULE_FLAG,

Line 2022: 'STANDARD_TB' L_DEF_TAXABLE_BASIS_FORMULA,

2018: 'Y' L_ALLOW_EXCEPTIONS_FLAG,
2019: 'N' L_ALLOW_RECOVERABILITY_FLAG,
2020: 'STANDARD_TC' L_DEF_TAX_CALC_FORMULA,
2021: 'Y' L_TAX_INCLUSIVE_OVERRIDE_FLAG,
2022: 'STANDARD_TB' L_DEF_TAXABLE_BASIS_FORMULA,
2023: 'SHIP_TO_SITE' L_DEF_REGISTR_PARTY_TYPE_CODE,
2024: 'N' L_REGISTRATION_TYPE_RULE_FLAG,
2025: 'N' L_REPORTING_ONLY_FLAG,
2026: 'N' L_AUTO_PRVN_FLAG,

Line 2434: 'STANDARD_TC' L_DEF_TAX_CALC_FORMULA,

2430: 'N' L_HAS_OTHER_JURISDICTIONS_FLAG,
2431: 'Y' L_ALLOW_EXEMPTIONS_FLAG,
2432: 'Y' L_ALLOW_EXCEPTIONS_FLAG,
2433: 'N' L_ALLOW_RECOVERABILITY_FLAG,
2434: 'STANDARD_TC' L_DEF_TAX_CALC_FORMULA,
2435: 'Y' L_TAX_INCLUSIVE_OVERRIDE_FLAG,
2436: 'STANDARD_TB' L_DEF_TAXABLE_BASIS_FORMULA,
2437: 'SHIP_TO_SITE' L_DEF_REGISTR_PARTY_TYPE_CODE,
2438: 'N' L_REGISTRATION_TYPE_RULE_FLAG,

Line 2436: 'STANDARD_TB' L_DEF_TAXABLE_BASIS_FORMULA,

2432: 'Y' L_ALLOW_EXCEPTIONS_FLAG,
2433: 'N' L_ALLOW_RECOVERABILITY_FLAG,
2434: 'STANDARD_TC' L_DEF_TAX_CALC_FORMULA,
2435: 'Y' L_TAX_INCLUSIVE_OVERRIDE_FLAG,
2436: 'STANDARD_TB' L_DEF_TAXABLE_BASIS_FORMULA,
2437: 'SHIP_TO_SITE' L_DEF_REGISTR_PARTY_TYPE_CODE,
2438: 'N' L_REGISTRATION_TYPE_RULE_FLAG,
2439: 'N' L_REPORTING_ONLY_FLAG,
2440: 'N' L_AUTO_PRVN_FLAG,

Line 2654: 'STANDARD' l_tax_status_code, --TAX_STATUS_CODE

2650: l_last_update_date,
2651: l_last_update_login
2652: )*/
2653: SELECT
2654: 'STANDARD' l_tax_status_code, --TAX_STATUS_CODE
2655: tax.content_owner_id l_content_owner_id, --CONTENT_OWNER_ID
2656: tax.effective_from l_effective_from, --EFFECTIVE_FROM
2657: NULL l_effective_to, --EFFECTIVE_TO
2658: tax.tax l_tax, --TAX

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

2694: FROM zx_status_b status
2695: WHERE tax.tax_regime_code = status.tax_regime_code
2696: AND tax.tax = status.tax
2697: AND tax.content_owner_id = status.content_owner_id --Bug 4563007
2698: AND status.tax_status_code = 'STANDARD');
2699:
2700:
2701: -- ****** Inserting rates for location tax codes ******
2702:

Line 2808: 'STANDARD_TB' , --taxable_basis_formula_code

2804: L_ADJ_FOR_ADHOC_AMT_CODE , --adj_for_adhoc_amt_code
2805: L_ALLOW_ADHOC_TAX_RATE_FLAG , --allow_adhoc_tax_rate_flag
2806: L_TAX_CLASS , --tax_class
2807: NULL , --source_id
2808: 'STANDARD_TB' , --taxable_basis_formula_code
2809: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
2810: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
2811: 'MIGRATED' , --record_type_code
2812: fnd_global.user_id , --created_by

Line 3017: AND status.tax_status_code = 'STANDARD'

3013: zx_party_tax_profile ptp,
3014: ar_system_parameters_all asp
3015: WHERE status.tax_regime_code like '%-SALES-TAX-%'
3016: AND status.tax = 'LOCATION'
3017: AND status.tax_status_code = 'STANDARD'
3018: AND status.content_owner_id = ptp.party_tax_profile_id
3019: AND ptp.party_type_code = 'OU'
3020: -- YK:02/22/2005
3021: AND ptp.party_id = codes.org_id

Line 3143: 'STANDARD_TB' , --taxable_basis_formula_code

3139: L_ADJ_FOR_ADHOC_AMT_CODE , --adj_for_adhoc_amt_code
3140: L_ALLOW_ADHOC_TAX_RATE_FLAG , --allow_adhoc_tax_rate_flag
3141: L_TAX_CLASS , --tax_class
3142: NULL , --source_id
3143: 'STANDARD_TB' , --taxable_basis_formula_code
3144: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
3145: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
3146: 'MIGRATED' , --record_type_code
3147: fnd_global.user_id , --created_by

Line 3352: AND status.tax_status_code = 'STANDARD'

3348: zx_party_tax_profile ptp,
3349: ar_system_parameters_all asp
3350: WHERE status.tax_regime_code like '%-SALES-TAX-%'
3351: AND status.tax = 'LOCATION'
3352: AND status.tax_status_code = 'STANDARD'
3353: AND status.content_owner_id = ptp.party_tax_profile_id
3354: AND ptp.party_type_code = 'OU'
3355: -- YK:02/22/2005
3356: AND ptp.party_id = codes.org_id

Line 3421: | Status Code : STANDARD

Line 3452: | Status Code : STANDARD

3448: |
3449: | Set live_for_processing_flag to 'Y' for these taxes
3450: | Set live_for_applicability_flag to 'N' for these taxes
3451: |
3452: | Status Code : STANDARD
3453: |
3454: | Rate Code : STATE, COUNTY, CITY tax rate codes for taxes
3455: | created during migration. They're owned by each content owner.
3456: |

Line 3913: 'STANDARD' l_tax_status_code, --TAX_STATUS_CODE

3909: l_request_id,
3910: 1
3911: )
3912: SELECT
3913: 'STANDARD' l_tax_status_code, --TAX_STATUS_CODE
3914: -99 l_content_owner_id, --CONTENT_OWNER_ID
3915: ztb.effective_from l_effective_from, --EFFECTIVE_FROM
3916: NULL l_effective_to, --EFFECTIVE_TO
3917: ztb.tax l_tax, --TAX

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

3957: FROM zx_status_b zsb
3958: WHERE zsb.tax_regime_code = ztb.tax_regime_code
3959: AND zsb.tax = ztb.tax
3960: AND zsb.content_owner_id = -99
3961: AND zsb.tax_status_code = 'STANDARD');
3962: ELSE
3963:
3964: INSERT ALL
3965: INTO ZX_STATUS_B_TMP

Line 4050: 'STANDARD' l_tax_status_code, --TAX_STATUS_CODE

4046: l_request_id,
4047: 1
4048: )
4049: SELECT
4050: 'STANDARD' l_tax_status_code, --TAX_STATUS_CODE
4051: -99 l_content_owner_id, --CONTENT_OWNER_ID
4052: ztb.effective_from l_effective_from, --EFFECTIVE_FROM
4053: NULL l_effective_to, --EFFECTIVE_TO
4054: ztb.tax l_tax, --TAX

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

4095: FROM zx_status_b zsb
4096: WHERE zsb.tax_regime_code = ztb.tax_regime_code
4097: AND zsb.tax = ztb.tax
4098: AND zsb.content_owner_id = -99
4099: AND zsb.tax_status_code = 'STANDARD');
4100:
4101:
4102: END IF;
4103:

Line 4218: 'STANDARD_TB' , --taxable_basis_formula_code

4214: L_ADJ_FOR_ADHOC_AMT_CODE , --adj_for_adhoc_amt_code
4215: L_ALLOW_ADHOC_TAX_RATE_FLAG , --allow_adhoc_tax_rate_flag
4216: L_TAX_CLASS , --tax_class
4217: NULL , --source_id
4218: 'STANDARD_TB' , --taxable_basis_formula_code
4219: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
4220: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
4221: 'MIGRATED' , --record_type_code
4222: fnd_global.user_id , --created_by

Line 4353: 'STANDARD' L_TAX_STATUS_CODE,

4349: avt.start_date L_EFFECTIVE_FROM,
4350: avt.end_date L_EFFECTIVE_TO,
4351: zrb.tax_regime_code L_TAX_REGIME_CODE ,
4352: ztb.tax L_TAX,
4353: 'STANDARD' L_TAX_STATUS_CODE,
4354: 'N' L_SCHEDULE_BASED_RATE_FLAG,
4355: 'PERCENTAGE' L_RATE_TYPE_CODE,
4356: avt.tax_rate L_PERCENTAGE_RATE,
4357: NULL L_QUANTITY_RATE,

Line 4550: 'STANDARD_TB' , --taxable_basis_formula_code

4546: L_ADJ_FOR_ADHOC_AMT_CODE , --adj_for_adhoc_amt_code
4547: L_ALLOW_ADHOC_TAX_RATE_FLAG , --allow_adhoc_tax_rate_flag
4548: L_TAX_CLASS , --tax_class
4549: NULL , --source_id
4550: 'STANDARD_TB' , --taxable_basis_formula_code
4551: L_INCLUSIVE_TAX_FLAG , --inclusive_tax_flag
4552: L_TAX_INCLUSIVE_OVERRIDE_FLAG , --tax_inclusive_override_flag
4553: 'MIGRATED' , --record_type_code
4554: fnd_global.user_id , --created_by

Line 4685: 'STANDARD' L_TAX_STATUS_CODE,

4681: avt.start_date L_EFFECTIVE_FROM,
4682: avt.end_date L_EFFECTIVE_TO,
4683: zrb.tax_regime_code L_TAX_REGIME_CODE ,
4684: ztb.tax L_TAX,
4685: 'STANDARD' L_TAX_STATUS_CODE,
4686: 'N' L_SCHEDULE_BASED_RATE_FLAG,
4687: 'PERCENTAGE' L_RATE_TYPE_CODE,
4688: avt.tax_rate L_PERCENTAGE_RATE,
4689: NULL L_QUANTITY_RATE,

Line 4843: 'STANDARD', --Status

4839: FOR k IN 1..content_owner_id_rec.count LOOP
4840: -- Create STATE tax rate code
4841: insert_tax_rate_code ('US-SALES-TAX-'|| TO_CHAR(location_structure_id_rec(k)), --Regime
4842: 'STATE', --Tax
4843: 'STANDARD', --Status
4844: 'STATE', --Rate
4845: content_owner_id_rec(k), --Content Owner ID
4846: org_id_rec(k), --Org ID
4847: 'Y', --Active Flag

Line 4856: 'STANDARD', --Status

4852: );
4853: -- COUNTY tax rate code
4854: insert_tax_rate_code ('US-SALES-TAX-'|| TO_CHAR(location_structure_id_rec(k)), --Regime
4855: 'COUNTY', --Tax
4856: 'STANDARD', --Status
4857: 'COUNTY', --Rate
4858: content_owner_id_rec(k), --Content Owner ID
4859: org_id_rec(k), --Org ID
4860: 'Y', --Active Flag

Line 4869: 'STANDARD', --Status

4865: );
4866: -- CITY tax rate code
4867: insert_tax_rate_code ('US-SALES-TAX-'|| TO_CHAR(location_structure_id_rec(k)), --Regime
4868: 'CITY', --Tax
4869: 'STANDARD', --Status
4870: 'CITY', --Rate
4871: content_owner_id_rec(k), --Content Owner ID
4872: org_id_rec(k), --Org ID
4873: 'Y', --Active Flag

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

5231: 'Y', 'RATES',
5232: 'N', NULL) ADJ_FOR_ADHOC_AMT_CODE,
5233: codes.validate_flag ALLOW_ADHOC_TAX_RATE_FLAG,
5234: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
5235: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT','STANDARD_TB') L_TAXABLE_BASIS_FORMULA,
5236: codes.DESCRIPTION DESCRIPTION ,-- Bug 4705196
5237: nvl(asp.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') ALLOW_EXEMPTIONS_FLAG,
5238: 'N' ALLOW_EXCEPTIONS_FLAG --Bug 5505935
5239: FROM

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

5578: 'Y', 'RATES',
5579: 'N', NULL) ADJ_FOR_ADHOC_AMT_CODE,
5580: codes.validate_flag ALLOW_ADHOC_TAX_RATE_FLAG,
5581: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
5582: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT','STANDARD_TB') L_TAXABLE_BASIS_FORMULA,
5583: codes.DESCRIPTION DESCRIPTION ,-- Bug 4705196
5584: nvl(asp.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') ALLOW_EXEMPTIONS_FLAG,
5585: 'N' ALLOW_EXCEPTIONS_FLAG --Bug 5505935
5586: FROM

Line 5867: 'O', 'STANDARD',

5863: codes.end_date EFFECTIVE_TO,
5864: params.global_attribute13 TAX_REGIME_CODE ,
5865: codes.global_attribute1 TAX,
5866: DECODE(codes.tax_class,
5867: 'O', 'STANDARD',
5868: 'I', 'STANDARD_AR_INPUT',
5869: 'STANDARD') TAX_STATUS_CODE,
5870: 'N' SCHEDULE_BASED_RATE_FLAG,
5871: 'PERCENTAGE' RATE_TYPE_CODE,

Line 5868: 'I', 'STANDARD_AR_INPUT',

5864: params.global_attribute13 TAX_REGIME_CODE ,
5865: codes.global_attribute1 TAX,
5866: DECODE(codes.tax_class,
5867: 'O', 'STANDARD',
5868: 'I', 'STANDARD_AR_INPUT',
5869: 'STANDARD') TAX_STATUS_CODE,
5870: 'N' SCHEDULE_BASED_RATE_FLAG,
5871: 'PERCENTAGE' RATE_TYPE_CODE,
5872: codes.tax_rate PERCENTAGE_RATE,

Line 5869: 'STANDARD') TAX_STATUS_CODE,

5865: codes.global_attribute1 TAX,
5866: DECODE(codes.tax_class,
5867: 'O', 'STANDARD',
5868: 'I', 'STANDARD_AR_INPUT',
5869: 'STANDARD') TAX_STATUS_CODE,
5870: 'N' SCHEDULE_BASED_RATE_FLAG,
5871: 'PERCENTAGE' RATE_TYPE_CODE,
5872: codes.tax_rate PERCENTAGE_RATE,
5873: NULL QUANTITY_RATE ,

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

5932: 'Y', 'RATES',
5933: 'N', NULL) ADJ_FOR_ADHOC_AMT_CODE,
5934: codes.validate_flag ALLOW_ADHOC_TAX_RATE_FLAG,
5935: DECODE(codes.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
5936: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT','STANDARD_TB') L_TAXABLE_BASIS_FORMULA,
5937: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
5938: FROM
5939: ar_vat_tax_all_b codes,
5940: zx_party_tax_profile ptp,

Line 6429: 'STANDARD_TC' , -- DEF_TAX_CALC_FORMULA

6425: -- Bug 4432896 : Set allow_exemptions_flag to 'Y'
6426: 'Y' , -- ALLOW_EXEMPTIONS_FLAG
6427: 'Y' , -- ALLOW_EXCEPTIONS_FLAG
6428: 'N' , -- ALLOW_RECOVERABILITY_FLAG
6429: 'STANDARD_TC' , -- DEF_TAX_CALC_FORMULA
6430: 'N' , -- TAX_INCLUSIVE_OVERRIDE_FLAG
6431: 'STANDARD_TB' , -- DEF_TAXABLE_BASIS_FORMULA
6432: 'SHIP_TO_SITE' , -- DEF_REGISTR_PARTY_TYPE_CODE
6433: 'N' , -- REGISTRATION_TYPE_RULE_FLAG

Line 6431: 'STANDARD_TB' , -- DEF_TAXABLE_BASIS_FORMULA

6427: 'Y' , -- ALLOW_EXCEPTIONS_FLAG
6428: 'N' , -- ALLOW_RECOVERABILITY_FLAG
6429: 'STANDARD_TC' , -- DEF_TAX_CALC_FORMULA
6430: 'N' , -- TAX_INCLUSIVE_OVERRIDE_FLAG
6431: 'STANDARD_TB' , -- DEF_TAXABLE_BASIS_FORMULA
6432: 'SHIP_TO_SITE' , -- DEF_REGISTR_PARTY_TYPE_CODE
6433: 'N' , -- REGISTRATION_TYPE_RULE_FLAG
6434: 'N' , -- REPORTING_ONLY_FLAG
6435: 'N' , -- AUTO_PRVN_FLAG

Line 7555: 'STANDARD_TC' ,--DEF_TAX_CALC_FORMULA

7551: 'N' ,--HAS_OTHER_JURISDICTIONS_FLAG
7552: ALLOW_EXEMPTIONS_FLAG ,--ALLOW_EXEMPTIONS_FLAG
7553: ALLOW_EXCEPTIONS_FLAG ,--ALLOW_EXCEPTIONS_FLAG
7554: 'N' ,--ALLOW_RECOVERABILITY_FLAG
7555: 'STANDARD_TC' ,--DEF_TAX_CALC_FORMULA
7556: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG --YK: 8/30/2004: Must be 'Y' as rate can be either 'Y' or 'N'.
7557: 'STANDARD_TB' ,--DEF_TAXABLE_BASIS_FORMULA --YK: 8/30/2004: Compounding
7558: 'SHIP_TO_SITE' ,--DEF_REGISTR_PARTY_TYPE_CODE
7559: 'N' ,--REGISTRATION_TYPE_RULE_FLAG

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

7553: ALLOW_EXCEPTIONS_FLAG ,--ALLOW_EXCEPTIONS_FLAG
7554: 'N' ,--ALLOW_RECOVERABILITY_FLAG
7555: 'STANDARD_TC' ,--DEF_TAX_CALC_FORMULA
7556: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG --YK: 8/30/2004: Must be 'Y' as rate can be either 'Y' or 'N'.
7557: 'STANDARD_TB' ,--DEF_TAXABLE_BASIS_FORMULA --YK: 8/30/2004: Compounding
7558: 'SHIP_TO_SITE' ,--DEF_REGISTR_PARTY_TYPE_CODE
7559: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
7560: 'N' ,--REPORTING_ONLY_FLAG
7561: 'N' ,--AUTO_PRVN_FLAG

Line 7908: 'STANDARD_TC' ,--DEF_TAX_CALC_FORMULA

7904: 'N' ,--HAS_OTHER_JURISDICTIONS_FLAG
7905: ALLOW_EXEMPTIONS_FLAG ,--ALLOW_EXEMPTIONS_FLAG
7906: ALLOW_EXCEPTIONS_FLAG ,--ALLOW_EXCEPTIONS_FLAG
7907: 'N' ,--ALLOW_RECOVERABILITY_FLAG
7908: 'STANDARD_TC' ,--DEF_TAX_CALC_FORMULA
7909: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG --YK: 8/30/2004: Must be 'Y' as rate can be either 'Y' or 'N'.
7910: 'STANDARD_TB' ,--DEF_TAXABLE_BASIS_FORMULA --YK: 8/30/2004: Compounding
7911: 'SHIP_TO_SITE' ,--DEF_REGISTR_PARTY_TYPE_CODE
7912: 'N' ,--REGISTRATION_TYPE_RULE_FLAG

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

7906: ALLOW_EXCEPTIONS_FLAG ,--ALLOW_EXCEPTIONS_FLAG
7907: 'N' ,--ALLOW_RECOVERABILITY_FLAG
7908: 'STANDARD_TC' ,--DEF_TAX_CALC_FORMULA
7909: 'Y' ,--TAX_INCLUSIVE_OVERRIDE_FLAG --YK: 8/30/2004: Must be 'Y' as rate can be either 'Y' or 'N'.
7910: 'STANDARD_TB' ,--DEF_TAXABLE_BASIS_FORMULA --YK: 8/30/2004: Compounding
7911: 'SHIP_TO_SITE' ,--DEF_REGISTR_PARTY_TYPE_CODE
7912: 'N' ,--REGISTRATION_TYPE_RULE_FLAG
7913: 'N' ,--REPORTING_ONLY_FLAG
7914: 'N' ,--AUTO_PRVN_FLAG

Line 10030: 'STANDARD_TB' , --taxable_basis_formula_code

10026: 'TAX_RATE' , --adj_for_adhoc_amt_code
10027: 'Y' , --allow_adhoc_tax_rate_flag
10028: 'OUTPUT' , --tax_class
10029: NULL , --source_id
10030: 'STANDARD_TB' , --taxable_basis_formula_code
10031: 'N' , --inclusive_tax_flag
10032: 'N' , --tax_inclusive_override_flag
10033: 'MIGRATED' , --record_type_code
10034: fnd_global.user_id , --created_by