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.OKS_EXTWAR_UTIL_PVT dependencies on OKC_RULES_V

Line 170: -- From okc_rules_v rul

166:
167:
168: -- Cursor Get_Rule_objectid_Csr Is
169: -- Select object1_id1
170: -- From okc_rules_v rul
171: -- ,okc_rule_groups_v rgp
172: -- Where rul.rgp_id = rgp.id
173: -- And rule_information_category = p_category
174: -- And jtot_object1_Code = p_object_Code

Line 180: from okc_rules_v

176:
177: -- Fixed Bug# 2281008
178: Cursor Get_Rule_objectid_Csr Is
179: Select object1_id1
180: from okc_rules_v
181: where rgp_id = (select id from okc_rule_groups_v where cle_id = p_cle_id)
182: And rule_information_category = p_category;
183:
184:

Line 213: From okc_rules_v rul

209: Is
210:
211: Cursor Get_Rule_objectid_Csr Is
212: Select object1_id1
213: From okc_rules_v rul
214: ,okc_rule_groups_v rgp
215: Where rul.rgp_id = rgp.id
216: And rule_information_category = p_category
217: And jtot_object1_Code = p_object_Code

Line 4482: From okc_rules_v rul

4478: Is
4479:
4480: Cursor Get_Rule_objectid_Csr Is
4481: Select object1_id1
4482: From okc_rules_v rul
4483: ,okc_rule_groups_v rgp
4484: Where rul.rgp_id = rgp.id
4485: And rule_information_category = p_category
4486: And jtot_object1_Code = p_object_Code

Line 4514: FROM okc_rules_v rul, okc_rule_groups_v rgp

4510: IS
4511: CURSOR get_rule_objectid_csr
4512: IS
4513: SELECT object1_id1
4514: FROM okc_rules_v rul, okc_rule_groups_v rgp
4515: WHERE rul.rgp_id = rgp.ID
4516: AND rule_information_category = p_category
4517: AND jtot_object1_code = p_object_code
4518: AND cle_id = p_cle_id;