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_TAX_DEFAULT_HIER dependencies on ZX_CONDITION_GROUPS_B

Line 510: | This routine inserts data INTO ZX_CONDITION_GROUPS_B,_TL for each of |

506: | PROCEDURE |
507: | create_condition_groups |
508: | |
509: | DESCRIPTION |
510: | This routine inserts data INTO ZX_CONDITION_GROUPS_B,_TL for each of |
511: | AP/PO default Hierarchy options defined in AP,PO system parameters |
512: | This routine has number of INSERT...SELECTs based on the AP,PO |
513: | Hierarchy setup.Each of the INSERT..SELECT is having UNION ALL of two|
514: | SELECT statements, |

Line 549: (select 1 from zx_condition_groups_b

545: --We will directly insert the LOOKUP CODE for INPUT CLASSIFICATION lookup types
546:
547: INSERT ALL
548: WHEN ( not exists
549: (select 1 from zx_condition_groups_b
550: where condition_group_code=l_condition_group_code)
551: ) THEN
552: INTO ZX_CONDITION_GROUPS_B
553: (

Line 552: INTO ZX_CONDITION_GROUPS_B

548: WHEN ( not exists
549: (select 1 from zx_condition_groups_b
550: where condition_group_code=l_condition_group_code)
551: ) THEN
552: INTO ZX_CONDITION_GROUPS_B
553: (
554: CONDITION_GROUP_CODE ,
555: DET_FACTOR_TEMPL_CODE ,
556: COUNTRY_CODE ,

Line 595: zx_condition_groups_b_s.nextval ,

591: DETERMINING_FACTOR_CQ1_CODE ,
592: OPERATOR1_CODE ,
593: ALPHANUMERIC_VALUE1 ,
594: 'MIGRATED' ,
595: zx_condition_groups_b_s.nextval ,
596: CONSTRAINT_ID ,
597: fnd_global.user_id ,
598: SYSDATE ,
599: fnd_global.user_id ,

Line 692: (select 1 from zx_condition_groups_b

688: --Tax Constraint Id will be appended if it is not null
689:
690: INSERT ALL
691: WHEN ( not exists
692: (select 1 from zx_condition_groups_b
693: where condition_group_code=l_condition_group_code)
694: ) THEN
695: INTO ZX_CONDITION_GROUPS_B
696: (

Line 695: INTO ZX_CONDITION_GROUPS_B

691: WHEN ( not exists
692: (select 1 from zx_condition_groups_b
693: where condition_group_code=l_condition_group_code)
694: ) THEN
695: INTO ZX_CONDITION_GROUPS_B
696: (
697: CONDITION_GROUP_CODE ,
698: DET_FACTOR_TEMPL_CODE ,
699: COUNTRY_CODE ,

Line 738: zx_condition_groups_b_s.nextval ,

734: DETERMINING_FACTOR_CQ1_CODE ,
735: OPERATOR1_CODE ,
736: ALPHANUMERIC_VALUE1 ,
737: 'MIGRATED' ,
738: zx_condition_groups_b_s.nextval ,
739: CONSTRAINT_ID ,
740: fnd_global.user_id ,
741: SYSDATE ,
742: fnd_global.user_id ,

Line 842: (select 1 from zx_condition_groups_b

838: -- det_factor_cq_code
839:
840: INSERT ALL
841: WHEN ( not exists
842: (select 1 from zx_condition_groups_b
843: where SUBSTR(condition_group_code, 1, 44) = SUBSTR(l_condition_group_code, 1,44)
844: and DET_FACTOR_TEMPL_CODE = l_det_factor_templ_code)
845: ) THEN
846: INTO ZX_CONDITION_GROUPS_B

Line 846: INTO ZX_CONDITION_GROUPS_B

842: (select 1 from zx_condition_groups_b
843: where SUBSTR(condition_group_code, 1, 44) = SUBSTR(l_condition_group_code, 1,44)
844: and DET_FACTOR_TEMPL_CODE = l_det_factor_templ_code)
845: ) THEN
846: INTO ZX_CONDITION_GROUPS_B
847: (
848: CONDITION_GROUP_CODE ,
849: DET_FACTOR_TEMPL_CODE ,
850: COUNTRY_CODE ,

Line 1084: zx_condition_groups_b_s.nextval ,

1080: END), --ALPHANUMERIC_VALUE4,
1081:
1082:
1083: 'MIGRATED' ,
1084: zx_condition_groups_b_s.nextval ,
1085: CONSTRAINT_ID ,
1086: fnd_global.user_id ,
1087: SYSDATE ,
1088: fnd_global.user_id ,

Line 1330: ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_CONDITION_GROUPS_B_S') l_condition_group_code,

1326:
1327: SELECT
1328: -- DISTINCT
1329: SUBSTRB(ar_vat.tax_code,1, 44)
1330: ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_CONDITION_GROUPS_B_S') l_condition_group_code,
1331: 'LEASE_MGT_RATE_DET_TEMPL' l_det_factor_templ_code,
1332: NULL COUNTRY_CODE ,
1333: 'N' MORE_THAN_MAX_COND_FLAG,
1334: 'Y' ENABLED_FLAG , --Bug 5090631

Line 1413: ZX_CONDITION_GROUPS_B B

1409: fnd_global.user_id ,
1410: fnd_global.conc_login_id
1411: FROM
1412: FND_LANGUAGES L,
1413: ZX_CONDITION_GROUPS_B B
1414: WHERE
1415: L.INSTALLED_FLAG in ('I', 'B')
1416: AND RECORD_TYPE_CODE = 'MIGRATED'
1417: AND not exists

Line 1442: | logic used while inserting the data in ZX_CONDITION_GROUPS_B. |

1438: | create_rules |
1439: | |
1440: | DESCRIPTION |
1441: | This routine inserts data into ZX_RULES_B/_TL by following the same |
1442: | logic used while inserting the data in ZX_CONDITION_GROUPS_B. |
1443: | |
1444: | SCOPE - PUBLIC |
1445: | |
1446: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2407: | logic used while inserting the data in ZX_CONDITION_GROUPS_B. |

2403: | create_process_results |
2404: | |
2405: | DESCRIPTION |
2406: | This routine inserts data into ZX_PROCESS_RESULTS by following same |
2407: | logic used while inserting the data in ZX_CONDITION_GROUPS_B. |
2408: | |
2409: | SCOPE - PUBLIC |
2410: | |
2411: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2524: ZX_CONDITION_GROUPS_B cond_groups,

2520: FROM
2521: ZX_RATES_B rates,
2522: FND_LOOKUPS fnd,
2523: ZX_RULES_B rules,
2524: ZX_CONDITION_GROUPS_B cond_groups,
2525: AP_TAX_CODES_ALL codes
2526: WHERE
2527: rates.record_type_code = 'MIGRATED'
2528: AND nvl(rates.source_id, rates.tax_rate_id) = codes.tax_id

Line 2567: ZX_CONDITION_GROUPS_B cond_groups

2563: AP_TAX_CODES_ALL GROUP_CODES,
2564: AP_TAX_CODES_ALL CODES,
2565: ZX_RATES_B rates,
2566: ZX_RULES_B rules,
2567: ZX_CONDITION_GROUPS_B cond_groups
2568: WHERE
2569: GROUP_CODES.TAX_ID = GROUPS.TAX_GROUP_ID
2570: AND GROUPS.TAX_GROUP_TYPE = 'AP'
2571: AND GROUPS.TAX_CODE_ID = CODES.TAX_ID

Line 2689: ZX_CONDITION_GROUPS_B cond_groups,

2685: NULL EXCEPTION_SET_ID
2686: FROM
2687: ZX_RATES_B rates,
2688: ZX_RULES_B rules,
2689: ZX_CONDITION_GROUPS_B cond_groups,
2690: AR_VAT_TAX_ALL_B codes,
2691: ar_system_parameters_all sys
2692: WHERE
2693: rates.RECORD_TYPE_CODE = 'MIGRATED'

Line 2745: ZX_CONDITION_GROUPS_B cond_groups

2741: AR_TAX_CONDITIONS_ALL cond,
2742: AR_TAX_CONDITIONS_ALL excp,
2743: ZX_RATES_B rates,
2744: ZX_RULES_B rules,
2745: ZX_CONDITION_GROUPS_B cond_groups
2746: WHERE
2747: gvat.vat_tax_id = gc.tax_group_id
2748: AND gc.tax_group_type = 'AR'
2749: AND gvat.tax_type = 'TAX_GROUP'

Line 2869: ZX_CONDITION_GROUPS_B CG,

2865: NULL CONDITION_SET_ID ,
2866: NULL EXCEPTION_SET_ID ,
2867: decode(vat.leasing_flag,'Y',vat.tax_code,'STANDARD') RATE_RESULT
2868: FROM ZX_TAXES_B TAXES,
2869: ZX_CONDITION_GROUPS_B CG,
2870: ZX_PARTY_TAX_PROFILE PTP,
2871: AR_VAT_TAX_ALL_B VAT ,
2872: ZX_RULES_B RULES,
2873: ar_system_parameters_all sys

Line 2923: ZX_CONDITION_GROUPS_B cond_groups,

2919: AR_TAX_CONDITIONS_ALL cond,
2920: AR_TAX_CONDITIONS_ALL excp,
2921: ZX_TAXES_B TAXES,
2922: ZX_RULES_B rules,
2923: ZX_CONDITION_GROUPS_B cond_groups,
2924: ZX_PARTY_TAX_PROFILE PTP,
2925: ar_system_parameters_all sys
2926: WHERE
2927: gvat.vat_tax_id = gc.tax_group_id

Line 3060: ZX_CONDITION_GROUPS_B cg

3056: FROM AR_VAT_TAX_ALL_B gvat,
3057: AR_TAX_GROUP_CODES_ALL taxgrp,
3058: ZX_TAXES_B TAXES,
3059: ZX_RULES_B rules,
3060: ZX_CONDITION_GROUPS_B cg
3061: WHERE gvat.vat_tax_id = taxgrp.tax_group_id
3062: AND taxgrp.tax_group_type = 'AR'
3063: AND gvat.tax_type = 'TAX_GROUP'
3064: AND taxgrp.product_fisc_classification ||

Line 3116: ZX_CONDITION_GROUPS_B cg,

3112: FROM AR_VAT_TAX_ALL_B gvat,
3113: AR_TAX_GROUP_CODES_ALL taxgrp,
3114: ZX_TAXES_B TAXES,
3115: ZX_RULES_B rules,
3116: ZX_CONDITION_GROUPS_B cg,
3117: ar_system_parameters_all sys,
3118: zx_party_tax_profile ptp
3119:
3120: WHERE taxgrp.tax_group_type = 'AR'

Line 3277: ZX_CONDITION_GROUPS_B cg,

3273: AR_TAX_GROUP_CODES_ALL taxgrp,
3274: AR_VAT_TAX_ALL_B vat,
3275: -- ZX_TAXES_B TAXES,
3276: ZX_RULES_B rules,
3277: ZX_CONDITION_GROUPS_B cg,
3278: ZX_RATES_B rates
3279: WHERE gvat.vat_tax_id = taxgrp.tax_group_id
3280: AND taxgrp.tax_group_type = 'AR'
3281: AND gvat.tax_type = 'TAX_GROUP'

Line 3333: ZX_CONDITION_GROUPS_B cg,

3329: AR_TAX_GROUP_CODES_ALL taxgrp,
3330: AR_VAT_TAX_ALL_B vat,
3331: ZX_TAXES_B TAXES,
3332: ZX_RULES_B rules,
3333: ZX_CONDITION_GROUPS_B cg,
3334: ar_system_parameters_all sys,
3335: zx_party_tax_profile ptp,
3336: ZX_RATES_B oklrates,
3337: ZX_RATES_B rates