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_MIGRATE_TAX_DEF dependencies on ZX_PROCESS_RESULTS

Line 9423: | This routine inserts data into ZX_RULES_B,_TL,ZX_PROCESS_RESULTS |

9419: | PROCEDURE |
9420: | create_rules |
9421: | |
9422: | DESCRIPTION |
9423: | This routine inserts data into ZX_RULES_B,_TL,ZX_PROCESS_RESULTS |
9424: | Based on AP recovery rules and associated rates. |
9425: | |
9426: | SCOPE - PUBLIC |
9427: | |

Line 9732: INSERT INTO ZX_PROCESS_RESULTS

9728:
9729: IF L_MULTI_ORG_FLAG = 'Y'
9730: THEN
9731:
9732: INSERT INTO ZX_PROCESS_RESULTS
9733: (
9734: CONDITION_GROUP_CODE ,
9735: PRIORITY ,
9736: RESULT_TYPE_CODE ,

Line 9794: zx_process_results_s.nextval ,--RESULT_ID

9790: 'N' ,--ALLOW_EXEMPTIONS_FLAG
9791: 'N' ,--ALLOW_EXCEPTIONS_FLAG
9792: 'MIGRATED' ,--RECORD_TYPE_CODE
9793: NULL ,--RESULT_API
9794: zx_process_results_s.nextval ,--RESULT_ID
9795: CONTENT_OWNER_ID ,--CONTENT_OWNER_ID
9796: CONDITION_GROUP_ID ,--CONDITION_GROUP_ID
9797: TAX_RULE_ID ,--TAX_RULE_ID
9798: fnd_global.user_id ,

Line 9861: AND not exists (select 1 from zx_process_results

9857: WHERE
9858: TEMP_GROUPS.RULE_ID = AP_RULES.RULE_ID
9859: AND TEMP_GROUPS.RATE_ID = AP_RATES.RATE_ID
9860: )
9861: AND not exists (select 1 from zx_process_results
9862: where tax_rule_id = zx_rules.tax_rule_id
9863: and condition_group_code = groups.condition_group_code
9864: and alphanumeric_result = 'STANDARD-' || AP_RATES.RECOVERY_RATE
9865: )

Line 9871: INSERT INTO ZX_PROCESS_RESULTS

9867: );
9868:
9869: ELSE
9870:
9871: INSERT INTO ZX_PROCESS_RESULTS
9872: (
9873: CONDITION_GROUP_CODE ,
9874: PRIORITY ,
9875: RESULT_TYPE_CODE ,

Line 9933: zx_process_results_s.nextval ,--RESULT_ID

9929: 'N' ,--ALLOW_EXEMPTIONS_FLAG
9930: 'N' ,--ALLOW_EXCEPTIONS_FLAG
9931: 'MIGRATED' ,--RECORD_TYPE_CODE
9932: NULL ,--RESULT_API
9933: zx_process_results_s.nextval ,--RESULT_ID
9934: CONTENT_OWNER_ID ,--CONTENT_OWNER_ID
9935: CONDITION_GROUP_ID ,--CONDITION_GROUP_ID
9936: TAX_RULE_ID ,--TAX_RULE_ID
9937: fnd_global.user_id ,

Line 10001: AND not exists (select 1 from zx_process_results

9997: WHERE
9998: TEMP_GROUPS.RULE_ID = AP_RULES.RULE_ID
9999: AND TEMP_GROUPS.RATE_ID = AP_RATES.RATE_ID
10000: )
10001: AND not exists (select 1 from zx_process_results
10002: where tax_rule_id = zx_rules.tax_rule_id
10003: and condition_group_code = groups.condition_group_code
10004: and alphanumeric_result = 'STANDARD-' || AP_RATES.RECOVERY_RATE
10005: )