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_FC_MIGRATE_PKG dependencies on ZX_FC_TYPES_REG_ASSOC

Line 690: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC

686: /* Regime Association to Fiscal Type */
687:
688: arp_util_tax.debug( 'Creating the regime association to fiscal type.. ');
689:
690: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC
691: (Tax_regime_code,
692: classification_type_code,
693: effective_FROM,
694: effective_to,

Line 714: zx_fc_types_reg_assoc_s.nextval,

710: SYSDATE,
711: fnd_global.user_id,
712: SYSDATE,
713: FND_GLOBAL.CONC_LOGIN_ID,
714: zx_fc_types_reg_assoc_s.nextval,
715: 1)
716: SELECT unique tax_regime_code
717: FROM ZX_RATES_B rates,
718: AP_TAX_CODES_ALL codes

Line 724: (select null from ZX_FC_TYPES_REG_ASSOC

720: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) and
721: codes.global_attribute_category = 'JE.HU.APXTADTC.TAX_ORIGIN' and
722: rates.record_type_code = 'MIGRATED' and
723: not exists
724: (select null from ZX_FC_TYPES_REG_ASSOC
725: where classification_type_code = 'STATISTICAL_CODE' and
726: tax_regime_code = rates.tax_regime_code);
727:
728: END IF; -- End of Hungary installed Checking

Line 993: ZX_FC_TYPES_REG_ASSOC

989: -- Create Regime Association for 'FISCAL CLASSIFICATION CODE'
990: arp_util_tax.debug( 'Creating the regime association to fiscal type.. ');
991:
992: INSERT ALL INTO
993: ZX_FC_TYPES_REG_ASSOC
994: (Tax_regime_code,
995: classification_type_code,
996: effective_FROM,
997: effective_to,

Line 1018: zx_fc_types_reg_assoc_s.nextval,

1014: SYSDATE,
1015: fnd_global.user_id,
1016: SYSDATE,
1017: FND_GLOBAL.CONC_LOGIN_ID,
1018: zx_fc_types_reg_assoc_s.nextval,
1019: 1)
1020: SELECT
1021: unique tax_regime_code
1022: FROM ZX_RATES_B rates,

Line 1029: (select null from ZX_FC_TYPES_REG_ASSOC

1025: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) and
1026: codes.global_attribute_category = 'JL.BR.INVIDITM.AR.Fiscal' and
1027: rates.record_type_code = 'MIGRATED' and
1028: not exists
1029: (select null from ZX_FC_TYPES_REG_ASSOC
1030: where classification_type_code = 'FISCAL_CLASSIFICATION' and
1031: tax_regime_code = rates.tax_regime_code);
1032:
1033:

Line 3031: ZX_FC_TYPES_REG_ASSOC

3027: arp_util_tax.debug('p_global_attribute_category = ' || p_global_attribute_category);
3028:
3029: /* Regime Association to Fiscal Type */
3030: INSERT ALL INTO
3031: ZX_FC_TYPES_REG_ASSOC
3032: ( Tax_regime_code,
3033: Classification_type_code,
3034: effective_from,
3035: effective_to,

Line 3055: zx_fc_types_reg_assoc_s.nextval,

3051: SYSDATE,
3052: fnd_global.user_id,
3053: SYSDATE,
3054: FND_GLOBAL.CONC_LOGIN_ID,
3055: zx_fc_types_reg_assoc_s.nextval,
3056: 1)
3057: Select unique
3058: tax_regime_code
3059: FROM ZX_RATES_B rates,

Line 3066: (select null from ZX_FC_TYPES_REG_ASSOC

3062: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) and
3063: codes.global_attribute_category = p_global_attribute_category and
3064: rates.record_type_code = 'MIGRATED' and
3065: not exists
3066: (select null from ZX_FC_TYPES_REG_ASSOC
3067: where classification_type_code = 'STATISTICAL CODE' and
3068: tax_regime_code = rates.tax_regime_code);
3069:
3070: arp_util_tax.debug('ASSOCIATE_ITEMS(-)');

Line 3531: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC

3527: /* Create Association to items Moved to zxitemcatmig.sql */
3528:
3529: /* Regime Association to Fiscal Type */
3530:
3531: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC
3532: (Tax_regime_code,
3533: Classification_type_code,
3534: effective_from,
3535: effective_to,

Line 3555: zx_fc_types_reg_assoc_s.NEXTVAL,

3551: SYSDATE,
3552: fnd_global.user_id,
3553: SYSDATE,
3554: FND_GLOBAL.CONC_LOGIN_ID,
3555: zx_fc_types_reg_assoc_s.NEXTVAL,
3556: 1)
3557: SELECT
3558: unique tax_regime_code
3559: FROM ZX_RATES_B rates,

Line 3566: (select null from ZX_FC_TYPES_REG_ASSOC

3562: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) and
3563: codes.global_attribute_category = 'JE.PL.APXTADTC.TAX_ORIGIN' and
3564: rates.record_type_code = 'MIGRATED' and
3565: not exists
3566: (select null from ZX_FC_TYPES_REG_ASSOC
3567: where classification_type_code = 'STATISTICAL_CODE' and
3568: tax_regime_code = rates.tax_regime_code);
3569:
3570: END IF; -- End of Poland checking

Line 4086: ZX_FC_TYPES_REG_ASSOC

4082: END IF;
4083:
4084: -- Create Regime Association for 'FISCAL CLASSIFICATION CODE'
4085: INSERT ALL INTO
4086: ZX_FC_TYPES_REG_ASSOC
4087: (Tax_regime_code,
4088: classification_type_code,
4089: effective_FROM,
4090: effective_to,

Line 4111: zx_fc_types_reg_assoc_s.NEXTVAL,

4107: SYSDATE,
4108: fnd_global.user_id,
4109: SYSDATE,
4110: FND_GLOBAL.CONC_LOGIN_ID,
4111: zx_fc_types_reg_assoc_s.NEXTVAL,
4112: 1)
4113:
4114: SELECT unique
4115: tax_regime_code

Line 4128: (select null from ZX_FC_TYPES_REG_ASSOC

4124: FROM ar_system_parameters_all
4125: WHERE global_attribute_category in ('JL.CO.ARXSYSPA.SYS_PARAMETERS',
4126: 'JL.BR.ARXSYSPA.Additional Info','JL.AR.ARXSYSPA.SYS_PARAMETERS')) and
4127: not exists
4128: (select null from ZX_FC_TYPES_REG_ASSOC
4129: where classification_type_code = 'FISCAL_CLASSIFICATION' and
4130: tax_regime_code = rates.tax_regime_code);
4131:
4132: -- Create the Second Level of Classification Codes for Transaction Condition Class

Line 4657: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC

4653: FC_TYPE_INSERT('LEASE_MGT_PROD_FISC_CLASS','Lease Management Product Fiscal Class',l_category_set);
4654:
4655: -- Regime Association
4656:
4657: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC
4658: (Tax_regime_code,
4659: classification_type_code,
4660: effective_FROM,
4661: effective_to,

Line 4681: zx_fc_types_reg_assoc_s.nextval,

4677: SYSDATE,
4678: fnd_global.user_id,
4679: SYSDATE,
4680: FND_GLOBAL.CONC_LOGIN_ID,
4681: zx_fc_types_reg_assoc_s.nextval,
4682: 1)
4683: SELECT unique rates.tax_regime_code
4684: FROM ZX_RATES_B rates,
4685: AR_VAT_TAX_ALL_B codes

Line 4690: (select null from ZX_FC_TYPES_REG_ASSOC

4686: WHERE codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id) and
4687: codes.leasing_flag = 'Y' and
4688: rates.record_type_code = 'MIGRATED' and
4689: not exists
4690: (select null from ZX_FC_TYPES_REG_ASSOC
4691: where classification_type_code = 'LEASE_MGT_PROD_FISC_CLASS'
4692: and tax_regime_code = rates.tax_regime_code);
4693:
4694: -- Disable Lookup Type