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.IBE_DSPMGRVALIDATION_GRP dependencies on FND_LOOKUP_VALUES

Line 270: select count(*) from FND_LOOKUP_VALUES_VL WHERE

266: FUNCTION check_valid_context_type(p_context_type in VARCHAR2)
267: RETURN boolean
268: IS
269: CURSOR valid_context_cur (p_context_type IN VARCHAR2) IS
270: select count(*) from FND_LOOKUP_VALUES_VL WHERE
271: lookup_type = 'JTF_AMV_DELV_TYPE_CODE' and
272: lookup_code = p_context_type and
273: enabled_flag = 'Y';
274:

Line 323: from FND_LOOKUP_VALUES_VL WHERE

319:
320: CURSOR valid_object_cur (p_object_type IN VARCHAR2) IS
321: -- select lookup_code
322: select 1
323: from FND_LOOKUP_VALUES_VL WHERE
324: lookup_type = 'IBE_RELATIONSHIP_RULE_OBJ_TYPE' and
325: lookup_code = p_object_type and
326: lookup_code <> 'N' and
327: enabled_flag = 'Y';

Line 1727: select COUNT(*) FROM FND_LOOKUP_VALUES WHERE lookup_type = c_lookup_type

1723: ) Return VARCHAR2 AS
1724: l_count NUMBER;
1725:
1726: Cursor c_check_lookup(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2) IS
1727: select COUNT(*) FROM FND_LOOKUP_VALUES WHERE lookup_type = c_lookup_type
1728: And lookup_code = c_lookup_code And enabled_flag = 'Y';
1729:
1730: BEGIN
1731: