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 512: | This routine inserts data INTO ZX_CONDITION_GROUPS_B,_TL for each of |

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

Line 551: (select 1 from zx_condition_groups_b

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

Line 555: INTO ZX_CONDITION_GROUPS_B

551: (select 1 from zx_condition_groups_b
552: where condition_group_code=l_condition_group_code
553: or condition_group_code = l_old_condition_group_code)
554: ) THEN
555: INTO ZX_CONDITION_GROUPS_B
556: (
557: CONDITION_GROUP_CODE ,
558: DET_FACTOR_TEMPL_CODE ,
559: COUNTRY_CODE ,

Line 598: zx_condition_groups_b_s.nextval ,

594: DETERMINING_FACTOR_CQ1_CODE ,
595: OPERATOR1_CODE ,
596: ALPHANUMERIC_VALUE1 ,
597: 'MIGRATED' ,
598: zx_condition_groups_b_s.nextval ,
599: CONSTRAINT_ID ,
600: fnd_global.user_id ,
601: SYSDATE ,
602: fnd_global.user_id ,

Line 697: (select 1 from zx_condition_groups_b

693: --Tax Constraint Id will be appended if it is not null
694:
695: INSERT ALL
696: WHEN ( not exists
697: (select 1 from zx_condition_groups_b
698: where condition_group_code=l_condition_group_code
699: or condition_group_code = l_old_condition_group_code)
700: ) THEN
701: INTO ZX_CONDITION_GROUPS_B

Line 701: INTO ZX_CONDITION_GROUPS_B

697: (select 1 from zx_condition_groups_b
698: where condition_group_code=l_condition_group_code
699: or condition_group_code = l_old_condition_group_code)
700: ) THEN
701: INTO ZX_CONDITION_GROUPS_B
702: (
703: CONDITION_GROUP_CODE ,
704: DET_FACTOR_TEMPL_CODE ,
705: COUNTRY_CODE ,

Line 744: zx_condition_groups_b_s.nextval ,

740: DETERMINING_FACTOR_CQ1_CODE ,
741: OPERATOR1_CODE ,
742: ALPHANUMERIC_VALUE1 ,
743: 'MIGRATED' ,
744: zx_condition_groups_b_s.nextval ,
745: CONSTRAINT_ID ,
746: fnd_global.user_id ,
747: SYSDATE ,
748: fnd_global.user_id ,

Line 854: (select 1 from zx_condition_groups_b

850: -- Bug 11937628
851:
852: INSERT ALL
853: WHEN ( not exists
854: (select 1 from zx_condition_groups_b
855: where condition_group_code=l_condition_group_code)
856: ) THEN
857: INTO ZX_CONDITION_GROUPS_B
858: (

Line 857: INTO ZX_CONDITION_GROUPS_B

853: WHEN ( not exists
854: (select 1 from zx_condition_groups_b
855: where condition_group_code=l_condition_group_code)
856: ) THEN
857: INTO ZX_CONDITION_GROUPS_B
858: (
859: CONDITION_GROUP_CODE ,
860: DET_FACTOR_TEMPL_CODE ,
861: COUNTRY_CODE ,

Line 900: zx_condition_groups_b_s.nextval ,

896: DETERMINING_FACTOR_CQ1_CODE ,
897: OPERATOR1_CODE ,
898: ALPHANUMERIC_VALUE1 ,
899: 'MIGRATED' ,
900: zx_condition_groups_b_s.nextval ,
901: CONSTRAINT_ID ,
902: fnd_global.user_id ,
903: SYSDATE ,
904: fnd_global.user_id ,

Line 998: (select 1 from zx_condition_groups_b

994: -- det_factor_cq_code
995:
996: INSERT ALL
997: WHEN ( not exists
998: (select 1 from zx_condition_groups_b
999: where SUBSTR(condition_group_code, 1, 44) = SUBSTR(l_condition_group_code, 1,44)
1000: and DET_FACTOR_TEMPL_CODE = l_det_factor_templ_code)
1001: ) THEN
1002: INTO ZX_CONDITION_GROUPS_B

Line 1002: INTO ZX_CONDITION_GROUPS_B

998: (select 1 from zx_condition_groups_b
999: where SUBSTR(condition_group_code, 1, 44) = SUBSTR(l_condition_group_code, 1,44)
1000: and DET_FACTOR_TEMPL_CODE = l_det_factor_templ_code)
1001: ) THEN
1002: INTO ZX_CONDITION_GROUPS_B
1003: (
1004: CONDITION_GROUP_CODE ,
1005: DET_FACTOR_TEMPL_CODE ,
1006: COUNTRY_CODE ,

Line 1240: zx_condition_groups_b_s.nextval ,

1236: END), --ALPHANUMERIC_VALUE4,
1237:
1238:
1239: 'MIGRATED' ,
1240: zx_condition_groups_b_s.nextval ,
1241: CONSTRAINT_ID ,
1242: fnd_global.user_id ,
1243: SYSDATE ,
1244: fnd_global.user_id ,

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

1482:
1483: SELECT
1484: -- DISTINCT
1485: SUBSTRB(ar_vat.tax_code,1, 44)
1486: ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_CONDITION_GROUPS_B_S') l_condition_group_code,
1487: 'LEASE_MGT_RATE_DET_TEMPL' l_det_factor_templ_code,
1488: NULL COUNTRY_CODE ,
1489: 'N' MORE_THAN_MAX_COND_FLAG,
1490: 'Y' ENABLED_FLAG , --Bug 5090631

Line 1569: ZX_CONDITION_GROUPS_B B

1565: fnd_global.user_id ,
1566: fnd_global.conc_login_id
1567: FROM
1568: FND_LANGUAGES L,
1569: ZX_CONDITION_GROUPS_B B
1570: WHERE
1571: L.INSTALLED_FLAG in ('I', 'B')
1572: AND RECORD_TYPE_CODE = 'MIGRATED'
1573: AND not exists

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

1594: | create_rules |
1595: | |
1596: | DESCRIPTION |
1597: | This routine inserts data into ZX_RULES_B/_TL by following the same |
1598: | logic used while inserting the data in ZX_CONDITION_GROUPS_B. |
1599: | |
1600: | SCOPE - PUBLIC |
1601: | |
1602: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

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

2569: | create_process_results |
2570: | |
2571: | DESCRIPTION |
2572: | This routine inserts data into ZX_PROCESS_RESULTS by following same |
2573: | logic used while inserting the data in ZX_CONDITION_GROUPS_B. |
2574: | |
2575: | SCOPE - PUBLIC |
2576: | |
2577: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2690: ZX_CONDITION_GROUPS_B cond_groups,

2686: FROM
2687: ZX_RATES_B rates,
2688: FND_LOOKUPS fnd,
2689: ZX_RULES_B rules,
2690: ZX_CONDITION_GROUPS_B cond_groups,
2691: AP_TAX_CODES_ALL codes
2692: WHERE
2693: rates.record_type_code = 'MIGRATED'
2694: AND nvl(rates.source_id, rates.tax_rate_id) = codes.tax_id

Line 2734: ZX_CONDITION_GROUPS_B cond_groups

2730: AP_TAX_CODES_ALL GROUP_CODES,
2731: AP_TAX_CODES_ALL CODES,
2732: ZX_RATES_B rates,
2733: ZX_RULES_B rules,
2734: ZX_CONDITION_GROUPS_B cond_groups
2735: WHERE
2736: GROUP_CODES.TAX_ID = GROUPS.TAX_GROUP_ID
2737: AND GROUPS.TAX_GROUP_TYPE = 'AP'
2738: AND GROUPS.TAX_CODE_ID = CODES.TAX_ID

Line 2856: ZX_CONDITION_GROUPS_B cond_groups,

2852: NULL EXCEPTION_SET_ID
2853: FROM
2854: ZX_RATES_B rates,
2855: ZX_RULES_B rules,
2856: ZX_CONDITION_GROUPS_B cond_groups,
2857: AR_VAT_TAX_ALL_B codes,
2858: ar_system_parameters_all sys
2859: WHERE
2860: rates.RECORD_TYPE_CODE = 'MIGRATED'

Line 2913: ZX_CONDITION_GROUPS_B cond_groups

2909: AR_TAX_CONDITIONS_ALL cond,
2910: AR_TAX_CONDITIONS_ALL excp,
2911: ZX_RATES_B rates,
2912: ZX_RULES_B rules,
2913: ZX_CONDITION_GROUPS_B cond_groups
2914: WHERE
2915: gvat.vat_tax_id = gc.tax_group_id
2916: AND gc.tax_group_type = 'AR'
2917: AND gvat.tax_type = 'TAX_GROUP'

Line 3044: ZX_CONDITION_GROUPS_B CG,

3040: NULL CONDITION_SET_ID ,
3041: NULL EXCEPTION_SET_ID ,
3042: decode(vat.leasing_flag,'Y',vat.tax_code,'STANDARD') RATE_RESULT
3043: FROM ZX_TAXES_B TAXES,
3044: ZX_CONDITION_GROUPS_B CG,
3045: ZX_PARTY_TAX_PROFILE PTP,
3046: AR_VAT_TAX_ALL_B VAT ,
3047: ZX_RULES_B RULES,
3048: ar_system_parameters_all sys

Line 3099: ZX_CONDITION_GROUPS_B cond_groups,

3095: AR_TAX_CONDITIONS_ALL cond,
3096: AR_TAX_CONDITIONS_ALL excp,
3097: ZX_TAXES_B TAXES,
3098: ZX_RULES_B rules,
3099: ZX_CONDITION_GROUPS_B cond_groups,
3100: ZX_PARTY_TAX_PROFILE PTP,
3101: ar_system_parameters_all sys
3102: WHERE
3103: gvat.vat_tax_id = gc.tax_group_id

Line 3243: ZX_CONDITION_GROUPS_B cg

3239: FROM AR_VAT_TAX_ALL_B gvat,
3240: AR_TAX_GROUP_CODES_ALL taxgrp,
3241: ZX_TAXES_B TAXES,
3242: ZX_RULES_B rules,
3243: ZX_CONDITION_GROUPS_B cg
3244: WHERE gvat.vat_tax_id = taxgrp.tax_group_id
3245: AND taxgrp.tax_group_type = 'AR'
3246: AND gvat.tax_type = 'TAX_GROUP'
3247: AND taxgrp.product_fisc_classification ||

Line 3299: ZX_CONDITION_GROUPS_B cg,

3295: FROM AR_VAT_TAX_ALL_B gvat,
3296: AR_TAX_GROUP_CODES_ALL taxgrp,
3297: ZX_TAXES_B TAXES,
3298: ZX_RULES_B rules,
3299: ZX_CONDITION_GROUPS_B cg,
3300: ar_system_parameters_all sys,
3301: zx_party_tax_profile ptp
3302:
3303: WHERE taxgrp.tax_group_type = 'AR'

Line 3460: ZX_CONDITION_GROUPS_B cg,

3456: AR_TAX_GROUP_CODES_ALL taxgrp,
3457: AR_VAT_TAX_ALL_B vat,
3458: -- ZX_TAXES_B TAXES,
3459: ZX_RULES_B rules,
3460: ZX_CONDITION_GROUPS_B cg,
3461: ZX_RATES_B rates
3462: WHERE gvat.vat_tax_id = taxgrp.tax_group_id
3463: AND taxgrp.tax_group_type = 'AR'
3464: AND gvat.tax_type = 'TAX_GROUP'

Line 3516: ZX_CONDITION_GROUPS_B cg,

3512: AR_TAX_GROUP_CODES_ALL taxgrp,
3513: AR_VAT_TAX_ALL_B vat,
3514: ZX_TAXES_B TAXES,
3515: ZX_RULES_B rules,
3516: ZX_CONDITION_GROUPS_B cg,
3517: ar_system_parameters_all sys,
3518: zx_party_tax_profile ptp,
3519: ZX_RATES_B oklrates,
3520: ZX_RATES_B rates