81: priority,
82: det_factor_templ_code,
83: effective_from,
84: 'N' simulated_flag,
85: fnd_global.user_id created_by,
86: sysdate creation_date,
87: fnd_global.user_id last_updated_by,
88: sysdate last_update_date,
89: last_update_login,
83: effective_from,
84: 'N' simulated_flag,
85: fnd_global.user_id created_by,
86: sysdate creation_date,
87: fnd_global.user_id last_updated_by,
88: sysdate last_update_date,
89: last_update_login,
90: effective_to,
91: application_id,
120: SELECT tax_rule_id,
121: language,
122: source_lang,
123: tax_rule_name,
124: fnd_global.user_id created_by,
125: sysdate creation_date,
126: fnd_global.user_id last_updated_by,
127: sysdate last_update_date,
128: last_update_login
122: source_lang,
123: tax_rule_name,
124: fnd_global.user_id created_by,
125: sysdate creation_date,
126: fnd_global.user_id last_updated_by,
127: sysdate last_update_date,
128: last_update_login
129: FROM zx_rules_tl
130: WHERE tax_rule_id IN (select sim_tax_rule_id
155: tax_rule_id,
156: condition_group_code,
157: priority,
158: 'N' simulated_flag,
159: fnd_global.user_id created_by,
160: sysdate creation_date,
161: fnd_global.user_id last_updated_by,
162: sysdate last_update_date,
163: last_update_login,
157: priority,
158: 'N' simulated_flag,
159: fnd_global.user_id created_by,
160: sysdate creation_date,
161: fnd_global.user_id last_updated_by,
162: sysdate last_update_date,
163: last_update_login,
164: result_type_code,
165: tax_status_code,
203: data_type_code,
204: operator_code,
205: ignore_flag,
206: 'N' simulated_flag,
207: fnd_global.user_id created_by,
208: sysdate creation_date,
209: fnd_global.user_id last_updated_by,
210: sysdate last_update_date,
211: last_update_login,
205: ignore_flag,
206: 'N' simulated_flag,
207: fnd_global.user_id created_by,
208: sysdate creation_date,
209: fnd_global.user_id last_updated_by,
210: sysdate last_update_date,
211: last_update_login,
212: tax_parameter_code,
213: determining_factor_cq_code,
425: value_high,
426: trx_line_id,
427: trx_id,
428: tax_line_number,
429: fnd_global.user_id,
430: sysdate,
431: fnd_global.user_id,
432: sysdate)
433: Select pr_detfactor_class_tab(j) determining_factor_class_code,
427: trx_id,
428: tax_line_number,
429: fnd_global.user_id,
430: sysdate,
431: fnd_global.user_id,
432: sysdate)
433: Select pr_detfactor_class_tab(j) determining_factor_class_code,
434: pr_detfactor_cq_tab(j) determining_factor_cq_code,
435: pr_detfactor_code_tab(j) determining_factor_code,
606: creation_date,
607: last_updated_by,
608: last_update_date)
609: SELECT l_rule_id sim_tax_rule_id,
610: fnd_global.user_id created_by,
611: sysdate creation_date,
612: fnd_global.user_id last_updated_by,
613: sysdate last_update_date
614: FROM dual
608: last_update_date)
609: SELECT l_rule_id sim_tax_rule_id,
610: fnd_global.user_id created_by,
611: sysdate creation_date,
612: fnd_global.user_id last_updated_by,
613: sysdate last_update_date
614: FROM dual
615: WHERE exists (Select 1
616: from zx_sim_conditions
656: value_low,
657: value_high,
658: 'N' ignore_flag,
659: 'Y' simulated_flag,
660: fnd_global.user_id created_by,
661: sysdate creation_date,
662: fnd_global.user_id last_updated_by,
663: sysdate last_update_date
664: FROM zx_sim_conditions
658: 'N' ignore_flag,
659: 'Y' simulated_flag,
660: fnd_global.user_id created_by,
661: sysdate creation_date,
662: fnd_global.user_id last_updated_by,
663: sysdate last_update_date
664: FROM zx_sim_conditions
665: WHERE trx_id = p_trx_id
666: and trx_line_id = p_trxline_id
733: creation_date,
734: last_updated_by,
735: last_update_date)
736: SELECT l_rule_id sim_tax_rule_id,
737: fnd_global.user_id created_by,
738: sysdate creation_date,
739: fnd_global.user_id last_updated_by,
740: sysdate last_update_date
741: FROM dual
735: last_update_date)
736: SELECT l_rule_id sim_tax_rule_id,
737: fnd_global.user_id created_by,
738: sysdate creation_date,
739: fnd_global.user_id last_updated_by,
740: sysdate last_update_date
741: FROM dual
742: WHERE exists (Select 1
743: from zx_sim_conditions
854: creation_date,
855: last_updated_by,
856: last_update_date)
857: SELECT l_rule_id sim_tax_rule_id,
858: fnd_global.user_id created_by,
859: sysdate creation_date,
860: fnd_global.user_id last_updated_by,
861: sysdate last_update_date
862: FROM dual
856: last_update_date)
857: SELECT l_rule_id sim_tax_rule_id,
858: fnd_global.user_id created_by,
859: sysdate creation_date,
860: fnd_global.user_id last_updated_by,
861: sysdate last_update_date
862: FROM dual
863: WHERE exists (Select 1
864: from zx_sim_conditions
926: userenv('LANG'),
927: b.tax_rule_code,
928: b.sim_tax_rule_id,
929: sysdate creation_date,
930: fnd_global.user_id created_by,
931: sysdate last_update_date,
932: fnd_global.user_id last_updated_by
933: from fnd_languages l,
934: zx_sim_rules_b b
928: b.sim_tax_rule_id,
929: sysdate creation_date,
930: fnd_global.user_id created_by,
931: sysdate last_update_date,
932: fnd_global.user_id last_updated_by
933: from fnd_languages l,
934: zx_sim_rules_b b
935: where l.installed_flag in ('I', 'B')
936: and not exists
1023: VALUES (to_number(substr(det_factor_templ_code,9)),
1024: det_factor_templ_code,
1025: 'TAX_RULES',
1026: 'USER_DEFINED',
1027: fnd_global.user_id,
1028: sysdate,
1029: fnd_global.user_id,
1030: sysdate)
1031: SELECT det_factor_templ_code
1025: 'TAX_RULES',
1026: 'USER_DEFINED',
1027: fnd_global.user_id,
1028: sysdate,
1029: fnd_global.user_id,
1030: sysdate)
1031: SELECT det_factor_templ_code
1032: FROM zx_sim_rules_b
1033: WHERE simulated_flag = 'Y'
1052: userenv('LANG'),
1053: b.det_factor_templ_code,
1054: b.det_factor_templ_id,
1055: sysdate creation_date,
1056: fnd_global.user_id created_by,
1057: sysdate last_update_date,
1058: fnd_global.user_id last_updated_by
1059: from fnd_languages l,
1060: zx_det_factor_templ_b b
1054: b.det_factor_templ_id,
1055: sysdate creation_date,
1056: fnd_global.user_id created_by,
1057: sysdate last_update_date,
1058: fnd_global.user_id last_updated_by
1059: from fnd_languages l,
1060: zx_det_factor_templ_b b
1061: where l.installed_flag in ('I', 'B')
1062: and exists (Select NULL
1093: determining_factor_cq_code,
1094: determining_factor_code,
1095: required_flag,
1096: 'USER_DEFINED',
1097: fnd_global.user_id,
1098: sysdate,
1099: fnd_global.user_id,
1100: sysdate)
1101: SELECT to_number(substr(rule.det_factor_templ_code,9)) det_factor_templ_id,
1095: required_flag,
1096: 'USER_DEFINED',
1097: fnd_global.user_id,
1098: sysdate,
1099: fnd_global.user_id,
1100: sysdate)
1101: SELECT to_number(substr(rule.det_factor_templ_code,9)) det_factor_templ_id,
1102: determining_factor_class_code,
1103: determining_factor_cq_code,
1136: det_factor_templ_code,
1137: 'USER_DEFINED',
1138: 'Y',
1139: 'Y',
1140: fnd_global.user_id,
1141: sysdate,
1142: fnd_global.user_id,
1143: sysdate)
1144: SELECT condition_group_code,
1138: 'Y',
1139: 'Y',
1140: fnd_global.user_id,
1141: sysdate,
1142: fnd_global.user_id,
1143: sysdate)
1144: SELECT condition_group_code,
1145: det_factor_templ_code
1146: FROM zx_sim_rules_b rule,
1168: userenv('LANG'),
1169: b.condition_group_code,
1170: b.condition_group_id,
1171: sysdate creation_date,
1172: fnd_global.user_id created_by,
1173: sysdate last_update_date,
1174: fnd_global.user_id last_updated_by
1175: from fnd_languages l,
1176: zx_condition_groups_b b
1170: b.condition_group_id,
1171: sysdate creation_date,
1172: fnd_global.user_id created_by,
1173: sysdate last_update_date,
1174: fnd_global.user_id last_updated_by
1175: from fnd_languages l,
1176: zx_condition_groups_b b
1177: where l.installed_flag in ('I', 'B')
1178: and exists (Select NULL
1382: determining_factor_code,
1383: data_type_code,
1384: operator_code,
1385: ignore_flag,
1386: fnd_global.user_id created_by,
1387: sysdate creation_date,
1388: fnd_global.user_id last_updated_by,
1389: sysdate last_update_date,
1390: tax_parameter_code,
1384: operator_code,
1385: ignore_flag,
1386: fnd_global.user_id created_by,
1387: sysdate creation_date,
1388: fnd_global.user_id last_updated_by,
1389: sysdate last_update_date,
1390: tax_parameter_code,
1391: determining_factor_cq_code,
1392: 'USER_DEFINED',
1432: det_factor_templ_code,
1433: effective_from,
1434: 'Y',
1435: 'USER_DEFINED',
1436: fnd_global.user_id created_by,
1437: sysdate creation_date,
1438: fnd_global.user_id last_updated_by,
1439: sysdate last_update_date
1440: FROM zx_sim_rules_b
1434: 'Y',
1435: 'USER_DEFINED',
1436: fnd_global.user_id created_by,
1437: sysdate creation_date,
1438: fnd_global.user_id last_updated_by,
1439: sysdate last_update_date
1440: FROM zx_sim_rules_b
1441: WHERE simulated_flag = 'Y';
1442:
1459: userenv('LANG'),
1460: b.tax_rule_code,
1461: b.tax_rule_id,
1462: sysdate creation_date,
1463: fnd_global.user_id created_by,
1464: sysdate last_update_date,
1465: fnd_global.user_id last_updated_by
1466: from fnd_languages l,
1467: zx_rules_b b
1461: b.tax_rule_id,
1462: sysdate creation_date,
1463: fnd_global.user_id created_by,
1464: sysdate last_update_date,
1465: fnd_global.user_id last_updated_by
1466: from fnd_languages l,
1467: zx_rules_b b
1468: where l.installed_flag in ('I', 'B')
1469: and exists (Select NULL
1524: result.numeric_result,
1525: result.alphanumeric_result,
1526: 'Y',
1527: 'USER_DEFINED',
1528: fnd_global.user_id created_by,
1529: sysdate creation_date,
1530: fnd_global.user_id last_updated_by,
1531: sysdate last_update_date
1532: FROM zx_sim_rules_b rule,
1526: 'Y',
1527: 'USER_DEFINED',
1528: fnd_global.user_id created_by,
1529: sysdate creation_date,
1530: fnd_global.user_id last_updated_by,
1531: sysdate last_update_date
1532: FROM zx_sim_rules_b rule,
1533: zx_sim_process_results result
1534: WHERE result.sim_tax_rule_id = rule.sim_tax_rule_id