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

Line 8970: | This routine inserts data into ZX_CONDITIONS,ZX_CONDITION_GROUPS_B,_TL|

8966: | PROCEDURE |
8967: | create_condition_groups |
8968: | |
8969: | DESCRIPTION |
8970: | This routine inserts data into ZX_CONDITIONS,ZX_CONDITION_GROUPS_B,_TL|
8971: | Based on AP recovery rules and associated rates. |
8972: | |
8973: | SCOPE - PUBLIC |
8974: | |

Line 9119: INSERT INTO ZX_CONDITION_GROUPS_B

9115:
9116: IF p_rate_id is NOT NULL THEN -- For bug 6148491
9117: IF L_MULTI_ORG_FLAG = 'Y'
9118: THEN
9119: INSERT INTO ZX_CONDITION_GROUPS_B
9120: (
9121: CONDITION_GROUP_CODE ,
9122: DET_FACTOR_TEMPL_CODE ,
9123: COUNTRY_CODE ,

Line 9203: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID

9199: NULL ,--VALUE_HIGH2
9200: 'MIGRATED' ,--RECORD_TYPE_CODE
9201: SOB.SET_OF_BOOKS_ID ,--LEDGER_ID
9202: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9203: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9204: fnd_global.user_id ,
9205: SYSDATE ,
9206: fnd_global.user_id ,
9207: SYSDATE ,

Line 9226: AND not exists (select 1 from zx_condition_groups_b

9222: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
9223: AND RULES.RULE_ID = RATES.RULE_ID
9224: --Added following conditions for Sync process
9225: AND RATES.RATE_ID = p_rate_id
9226: AND not exists (select 1 from zx_condition_groups_b
9227: where CONDITION_GROUP_CODE IN
9228: (SELECT TEMP_GROUPS.CONDITION_GROUP_CODE
9229: FROM
9230: -- Bug 6148491

Line 9251: INSERT INTO ZX_CONDITION_GROUPS_B

9247: )
9248: )
9249: ;
9250: ELSE -- If Multi_org_flag is NOT Y
9251: INSERT INTO ZX_CONDITION_GROUPS_B
9252: (
9253: CONDITION_GROUP_CODE ,
9254: DET_FACTOR_TEMPL_CODE ,
9255: COUNTRY_CODE ,

Line 9335: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID

9331: NULL ,--VALUE_HIGH2
9332: 'MIGRATED' ,--RECORD_TYPE_CODE
9333: SOB.SET_OF_BOOKS_ID ,--LEDGER_ID
9334: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9335: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9336: fnd_global.user_id ,
9337: SYSDATE ,
9338: fnd_global.user_id ,
9339: SYSDATE ,

Line 9359: AND not exists (select 1 from zx_condition_groups_b

9355: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
9356: AND RULES.RULE_ID = RATES.RULE_ID
9357: --Added following conditions for Sync process
9358: AND RATES.RATE_ID = p_rate_id
9359: AND not exists (select 1 from zx_condition_groups_b
9360: where CONDITION_GROUP_CODE IN
9361: (SELECT TEMP_GROUPS.CONDITION_GROUP_CODE
9362: FROM
9363: -- Bug 6148491

Line 9388: INSERT INTO ZX_CONDITION_GROUPS_B

9384:
9385: ELSE -- If p_rate_id is NULL
9386: IF L_MULTI_ORG_FLAG = 'Y'
9387: THEN
9388: INSERT INTO ZX_CONDITION_GROUPS_B
9389: (
9390: CONDITION_GROUP_CODE ,
9391: DET_FACTOR_TEMPL_CODE ,
9392: COUNTRY_CODE ,

Line 9473: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID

9469: NULL ,--VALUE_HIGH2
9470: 'MIGRATED' ,--RECORD_TYPE_CODE
9471: SOB.SET_OF_BOOKS_ID ,--LEDGER_ID
9472: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9473: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9474: fnd_global.user_id ,
9475: SYSDATE ,
9476: fnd_global.user_id ,
9477: SYSDATE ,

Line 9496: AND not exists (select 1 from zx_condition_groups_b

9492: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
9493: AND RULES.RULE_ID = RATES.RULE_ID
9494: --Added following conditions for Sync process
9495: --AND RATES.RATE_ID = nvl(p_rate_id,RATES.RATE_ID)
9496: AND not exists (select 1 from zx_condition_groups_b
9497: where CONDITION_GROUP_CODE IN
9498: (SELECT TEMP_GROUPS.CONDITION_GROUP_CODE
9499: FROM
9500: -- Bug 6148491

Line 9522: INSERT INTO ZX_CONDITION_GROUPS_B

9518: )
9519: ;
9520: ELSE
9521:
9522: INSERT INTO ZX_CONDITION_GROUPS_B
9523: (
9524: CONDITION_GROUP_CODE ,
9525: DET_FACTOR_TEMPL_CODE ,
9526: COUNTRY_CODE ,

Line 9607: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID

9603: NULL ,--VALUE_HIGH2
9604: 'MIGRATED' ,--RECORD_TYPE_CODE
9605: SOB.SET_OF_BOOKS_ID ,--LEDGER_ID
9606: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9607: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9608: fnd_global.user_id ,
9609: SYSDATE ,
9610: fnd_global.user_id ,
9611: SYSDATE ,

Line 9631: AND not exists (select 1 from zx_condition_groups_b

9627: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
9628: AND RULES.RULE_ID = RATES.RULE_ID
9629: --Added following conditions for Sync process
9630: --AND RATES.RATE_ID = nvl(p_rate_id,RATES.RATE_ID)
9631: AND not exists (select 1 from zx_condition_groups_b
9632: where CONDITION_GROUP_CODE IN
9633: (SELECT TEMP_GROUPS.CONDITION_GROUP_CODE
9634: FROM
9635: -- Bug 6148491

Line 9692: ZX_CONDITION_GROUPS_B B

9688: fnd_global.user_id ,
9689: fnd_global.conc_login_id
9690: FROM
9691: FND_LANGUAGES L,
9692: ZX_CONDITION_GROUPS_B B
9693: WHERE
9694: L.INSTALLED_FLAG in ('I', 'B')
9695: AND RECORD_TYPE_CODE = 'MIGRATED'
9696: AND not exists

Line 10126: ZX_CONDITION_GROUPS_B GROUPS,

10122: ap_tax_recvry_rules_all AP_RULES,
10123: ap_tax_recvry_rates_all AP_RATES,
10124: ZX_RATES_B ZX_RATES,
10125: ZX_RULES_B ZX_RULES,
10126: ZX_CONDITION_GROUPS_B GROUPS,
10127: zx_party_tax_profile ptp
10128: WHERE
10129: CODES.TAX_ID = NVL(ZX_RATES.SOURCE_ID, ZX_RATES.TAX_RATE_ID)
10130: AND CODES.TAX_RECOVERY_RULE_ID = AP_RULES.RULE_ID

Line 10282: ZX_CONDITION_GROUPS_B GROUPS,

10278: ap_tax_recvry_rules_all AP_RULES,
10279: ap_tax_recvry_rates_all AP_RATES,
10280: ZX_RATES_B ZX_RATES,
10281: ZX_RULES_B ZX_RULES,
10282: ZX_CONDITION_GROUPS_B GROUPS,
10283: zx_party_tax_profile ptp
10284: WHERE
10285: CODES.TAX_ID = NVL(ZX_RATES.SOURCE_ID, ZX_RATES.TAX_RATE_ID)
10286: AND CODES.TAX_RECOVERY_RULE_ID = AP_RULES.RULE_ID