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 8945: | This routine inserts data into ZX_CONDITIONS,ZX_CONDITION_GROUPS_B,_TL|

8941: | PROCEDURE |
8942: | create_condition_groups |
8943: | |
8944: | DESCRIPTION |
8945: | This routine inserts data into ZX_CONDITIONS,ZX_CONDITION_GROUPS_B,_TL|
8946: | Based on AP recovery rules and associated rates. |
8947: | |
8948: | SCOPE - PUBLIC |
8949: | |

Line 9096: INSERT INTO ZX_CONDITION_GROUPS_B

9092:
9093: IF L_MULTI_ORG_FLAG = 'Y'
9094: THEN
9095:
9096: INSERT INTO ZX_CONDITION_GROUPS_B
9097: (
9098: CONDITION_GROUP_CODE ,
9099: DET_FACTOR_TEMPL_CODE ,
9100: COUNTRY_CODE ,

Line 9181: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID

9177: NULL ,--VALUE_HIGH2
9178: 'MIGRATED' ,--RECORD_TYPE_CODE
9179: SOB.SET_OF_BOOKS_ID ,--LEDGER_ID
9180: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9181: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9182: fnd_global.user_id ,
9183: SYSDATE ,
9184: fnd_global.user_id ,
9185: SYSDATE ,

Line 9204: AND not exists (select 1 from zx_condition_groups_b

9200: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
9201: AND RULES.RULE_ID = RATES.RULE_ID
9202: --Added following conditions for Sync process
9203: AND RATES.RATE_ID = nvl(p_rate_id,RATES.RATE_ID)
9204: AND not exists (select 1 from zx_condition_groups_b
9205: where CONDITION_GROUP_CODE =
9206: (SELECT TEMP_GROUPS.CONDITION_GROUP_CODE
9207: FROM
9208: (SELECT substrb(RULES1.NAME,1,24) || '-' || ROW_NUMBER()

Line 9227: INSERT INTO ZX_CONDITION_GROUPS_B

9223: )
9224: ;
9225: ELSE
9226:
9227: INSERT INTO ZX_CONDITION_GROUPS_B
9228: (
9229: CONDITION_GROUP_CODE ,
9230: DET_FACTOR_TEMPL_CODE ,
9231: COUNTRY_CODE ,

Line 9312: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID

9308: NULL ,--VALUE_HIGH2
9309: 'MIGRATED' ,--RECORD_TYPE_CODE
9310: SOB.SET_OF_BOOKS_ID ,--LEDGER_ID
9311: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9312: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9313: fnd_global.user_id ,
9314: SYSDATE ,
9315: fnd_global.user_id ,
9316: SYSDATE ,

Line 9336: AND not exists (select 1 from zx_condition_groups_b

9332: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
9333: AND RULES.RULE_ID = RATES.RULE_ID
9334: --Added following conditions for Sync process
9335: AND RATES.RATE_ID = nvl(p_rate_id,RATES.RATE_ID)
9336: AND not exists (select 1 from zx_condition_groups_b
9337: where CONDITION_GROUP_CODE =
9338: (SELECT TEMP_GROUPS.CONDITION_GROUP_CODE
9339: FROM
9340: (SELECT substrb(RULES1.NAME,1,24) || '-' || ROW_NUMBER()

Line 9394: ZX_CONDITION_GROUPS_B B

9390: fnd_global.user_id ,
9391: fnd_global.conc_login_id
9392: FROM
9393: FND_LANGUAGES L,
9394: ZX_CONDITION_GROUPS_B B
9395: WHERE
9396: L.INSTALLED_FLAG in ('I', 'B')
9397: AND RECORD_TYPE_CODE = 'MIGRATED'
9398: AND not exists

Line 9829: ZX_CONDITION_GROUPS_B GROUPS,

9825: ap_tax_recvry_rules_all AP_RULES,
9826: ap_tax_recvry_rates_all AP_RATES,
9827: ZX_RATES_B ZX_RATES,
9828: ZX_RULES_B ZX_RULES,
9829: ZX_CONDITION_GROUPS_B GROUPS,
9830: zx_party_tax_profile ptp
9831: WHERE
9832: CODES.TAX_ID = NVL(ZX_RATES.SOURCE_ID, ZX_RATES.TAX_RATE_ID)
9833: AND CODES.TAX_RECOVERY_RULE_ID = AP_RULES.RULE_ID

Line 9968: ZX_CONDITION_GROUPS_B GROUPS,

9964: ap_tax_recvry_rules_all AP_RULES,
9965: ap_tax_recvry_rates_all AP_RATES,
9966: ZX_RATES_B ZX_RATES,
9967: ZX_RULES_B ZX_RULES,
9968: ZX_CONDITION_GROUPS_B GROUPS,
9969: zx_party_tax_profile ptp
9970: WHERE
9971: CODES.TAX_ID = NVL(ZX_RATES.SOURCE_ID, ZX_RATES.TAX_RATE_ID)
9972: AND CODES.TAX_RECOVERY_RULE_ID = AP_RULES.RULE_ID