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.

[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on ZX_FC_TYPES_REG_ASSOC

Line 703: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC

699: /* Regime Association to Fiscal Type */
700:
701: arp_util_tax.debug( 'Creating the regime association to fiscal type.. ');
702:
703: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC
704: (Tax_regime_code,
705: classification_type_code,
706: effective_FROM,
707: effective_to,

Line 727: zx_fc_types_reg_assoc_s.nextval,

723: SYSDATE,
724: fnd_global.user_id,
725: SYSDATE,
726: FND_GLOBAL.CONC_LOGIN_ID,
727: zx_fc_types_reg_assoc_s.nextval,
728: 1)
729: SELECT unique tax_regime_code
730: FROM ZX_RATES_B rates,
731: AP_TAX_CODES_ALL codes

Line 737: from ZX_FC_TYPES_REG_ASSOC

733: and codes.global_attribute_category = 'JE.HU.APXTADTC.TAX_ORIGIN'
734: and rates.record_type_code = 'MIGRATED'
735: and not exists
736: (select null
737: from ZX_FC_TYPES_REG_ASSOC
738: where classification_type_code = 'STATISTICAL_CODE'
739: and tax_regime_code = rates.tax_regime_code);
740:
741: END IF; -- End of Hungary installed Checking

Line 1004: ZX_FC_TYPES_REG_ASSOC

1000: -- Create Regime Association for 'FISCAL CLASSIFICATION CODE'
1001: arp_util_tax.debug( 'Creating the regime association to fiscal type.. ');
1002:
1003: INSERT ALL INTO
1004: ZX_FC_TYPES_REG_ASSOC
1005: (Tax_regime_code,
1006: classification_type_code,
1007: effective_FROM,
1008: effective_to,

Line 1029: zx_fc_types_reg_assoc_s.nextval,

1025: SYSDATE,
1026: fnd_global.user_id,
1027: SYSDATE,
1028: FND_GLOBAL.CONC_LOGIN_ID,
1029: zx_fc_types_reg_assoc_s.nextval,
1030: 1)
1031: SELECT
1032: unique tax_regime_code
1033: FROM ZX_RATES_B rates,

Line 1040: from ZX_FC_TYPES_REG_ASSOC

1036: and codes.global_attribute_category = 'JL.BR.INVIDITM.AR.Fiscal'
1037: and rates.record_type_code = 'MIGRATED'
1038: and not exists
1039: (select null
1040: from ZX_FC_TYPES_REG_ASSOC
1041: where classification_type_code = 'FISCAL_CLASSIFICATION'
1042: and tax_regime_code = rates.tax_regime_code);
1043:
1044: arp_util_tax.debug( ' Calling the bulk api to create categories..(-)');

Line 3062: ZX_FC_TYPES_REG_ASSOC

3058: arp_util_tax.debug('p_global_attribute_category = ' || p_global_attribute_category);
3059:
3060: /* Regime Association to Fiscal Type */
3061: INSERT ALL INTO
3062: ZX_FC_TYPES_REG_ASSOC
3063: ( Tax_regime_code,
3064: Classification_type_code,
3065: effective_from,
3066: effective_to,

Line 3086: zx_fc_types_reg_assoc_s.nextval,

3082: SYSDATE,
3083: fnd_global.user_id,
3084: SYSDATE,
3085: FND_GLOBAL.CONC_LOGIN_ID,
3086: zx_fc_types_reg_assoc_s.nextval,
3087: 1)
3088: Select unique
3089: tax_regime_code
3090: FROM ZX_RATES_B rates,

Line 3097: (select null from ZX_FC_TYPES_REG_ASSOC

3093: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) and
3094: codes.global_attribute_category = p_global_attribute_category and
3095: rates.record_type_code = 'MIGRATED' and
3096: not exists
3097: (select null from ZX_FC_TYPES_REG_ASSOC
3098: where classification_type_code = 'STATISTICAL CODE' and
3099: tax_regime_code = rates.tax_regime_code);
3100:
3101: arp_util_tax.debug('ASSOCIATE_ITEMS(-)');

Line 3505: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC

3501:
3502: -- Creating the regime association for Vendor Type rules
3503: -- Bug 13963357
3504:
3505: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC
3506: ( Tax_regime_code,
3507: classification_type_code,
3508: effective_FROM,
3509: effective_to,

Line 3529: zx_fc_types_reg_assoc_s.nextval,

3525: SYSDATE,
3526: fnd_global.user_id,
3527: SYSDATE,
3528: FND_GLOBAL.CONC_LOGIN_ID,
3529: zx_fc_types_reg_assoc_s.nextval,
3530: 1)
3531: SELECT unique rates.tax_regime_code
3532: FROM ZX_RATES_B rates,
3533: ap_tax_codes_all codes,

Line 3542: ( select 1 from ZX_FC_TYPES_REG_ASSOC

3538: and codes.tax_recovery_rule_id = rules.rule_id
3539: and rules.rule_id = rec_rates.rule_id
3540: and rec_rates.condition is not null
3541: and not exists
3542: ( select 1 from ZX_FC_TYPES_REG_ASSOC
3543: where classification_type_code = 'ESTB_TAX_CLASSIFICATION'
3544: and tax_regime_code = rates.tax_regime_code);
3545:
3546: FC_PARTY_TYPE_INSERT('ESTB_TAX_CLASSIFICATION','Establishment Tax Classification','VENDOR TYPE');

Line 3730: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC

3726: /* Create Association to items Moved to zxitemcatmig.sql */
3727:
3728: /* Regime Association to Fiscal Type */
3729:
3730: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC
3731: (Tax_regime_code,
3732: Classification_type_code,
3733: effective_from,
3734: effective_to,

Line 3754: zx_fc_types_reg_assoc_s.NEXTVAL,

3750: SYSDATE,
3751: fnd_global.user_id,
3752: SYSDATE,
3753: FND_GLOBAL.CONC_LOGIN_ID,
3754: zx_fc_types_reg_assoc_s.NEXTVAL,
3755: 1)
3756: SELECT
3757: unique tax_regime_code
3758: FROM ZX_RATES_B rates,

Line 3765: (select null from ZX_FC_TYPES_REG_ASSOC

3761: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) and
3762: codes.global_attribute_category = 'JE.PL.APXTADTC.TAX_ORIGIN' and
3763: rates.record_type_code = 'MIGRATED' and
3764: not exists
3765: (select null from ZX_FC_TYPES_REG_ASSOC
3766: where classification_type_code = 'STATISTICAL_CODE' and
3767: tax_regime_code = rates.tax_regime_code);
3768:
3769: END IF; -- End of Poland checking

Line 4287: ZX_FC_TYPES_REG_ASSOC

4283: END IF;
4284:
4285: -- Create Regime Association for 'FISCAL CLASSIFICATION CODE'
4286: INSERT ALL INTO
4287: ZX_FC_TYPES_REG_ASSOC
4288: (Tax_regime_code,
4289: classification_type_code,
4290: effective_FROM,
4291: effective_to,

Line 4312: zx_fc_types_reg_assoc_s.NEXTVAL,

4308: SYSDATE,
4309: fnd_global.user_id,
4310: SYSDATE,
4311: FND_GLOBAL.CONC_LOGIN_ID,
4312: zx_fc_types_reg_assoc_s.NEXTVAL,
4313: 1)
4314:
4315: SELECT unique
4316: tax_regime_code

Line 4329: (select null from ZX_FC_TYPES_REG_ASSOC

4325: FROM ar_system_parameters_all
4326: WHERE global_attribute_category in ('JL.CO.ARXSYSPA.SYS_PARAMETERS',
4327: 'JL.BR.ARXSYSPA.Additional Info','JL.AR.ARXSYSPA.SYS_PARAMETERS')) and
4328: not exists
4329: (select null from ZX_FC_TYPES_REG_ASSOC
4330: where classification_type_code = 'FISCAL_CLASSIFICATION' and
4331: tax_regime_code = rates.tax_regime_code);
4332:
4333: -- Create the Second Level of Classification Codes for Transaction Condition Class

Line 4881: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC

4877: FC_TYPE_INSERT('LEASE_MGT_PROD_FISC_CLASS','Lease Management Product Fiscal Class',l_category_set);
4878:
4879: -- Regime Association
4880:
4881: INSERT ALL INTO ZX_FC_TYPES_REG_ASSOC
4882: (Tax_regime_code,
4883: classification_type_code,
4884: effective_FROM,
4885: effective_to,

Line 4905: zx_fc_types_reg_assoc_s.nextval,

4901: SYSDATE,
4902: fnd_global.user_id,
4903: SYSDATE,
4904: FND_GLOBAL.CONC_LOGIN_ID,
4905: zx_fc_types_reg_assoc_s.nextval,
4906: 1)
4907: SELECT unique rates.tax_regime_code
4908: FROM ZX_RATES_B rates,
4909: AR_VAT_TAX_ALL_B codes

Line 4914: (select null from ZX_FC_TYPES_REG_ASSOC

4910: WHERE codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id) and
4911: codes.leasing_flag = 'Y' and
4912: rates.record_type_code = 'MIGRATED' and
4913: not exists
4914: (select null from ZX_FC_TYPES_REG_ASSOC
4915: where classification_type_code = 'LEASE_MGT_PROD_FISC_CLASS'
4916: and tax_regime_code = rates.tax_regime_code);
4917:
4918: -- Disable Lookup Type