APPS.IEU_DIAGNOSTICS_PVT dependencies on FND_LOOKUP_VALUES

Line 1217: fnd_lookup_values l

1213: distinct l.meaning node_name,
1214: e.SEL_ENUM_ID enum_id
1215: FROM
1216: IEU_UWQ_SEL_ENUMERATORS e,
1217: fnd_lookup_values l
1218: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
1219: where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
1220: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
1221: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')

Line 1722: fnd_lookup_values v

1718: cursor c_dproc (enum_id NUMBER, app_id NUMBER, l_type VARCHAR2, l_code VARCHAR2)is
1719: select distinct v.meaning, s.sel_enum_id, s.enum_proc, tl.application_name
1720: from ieu_uwq_sel_enumerators s,
1721: fnd_application_tl tl,
1722: fnd_lookup_values v
1723: where s.sel_enum_id = enum_id
1724: and tl.application_id = app_id
1725: and v.lookup_type = l_type
1726: and v.lookup_code = l_code

Line 1794: from IEU_UWQ_SEL_ENUMERATORS u, FND_LOOKUP_VALUES lu

1790: t1 := DBMS_UTILITY.GET_TIME;
1791:
1792: --get the details of a node
1793: /* SELECT lu.MEANING into l_vnode_label
1794: from IEU_UWQ_SEL_ENUMERATORS u, FND_LOOKUP_VALUES lu
1795: where
1796: u.WORK_Q_LABEL_LU_TYPE = lu.LOOKUP_TYPE
1797: and u.WORK_Q_LABEL_LU_CODE = lu.LOOKUP_CODE
1798: and u.SEL_ENUM_ID =c_rec.SEL_ENUM_ID;*/

Line 1804: fnd_lookup_values v

1800:
1801: select distinct v.meaning into l_vnode_label
1802: from ieu_uwq_sel_enumerators s,
1803: fnd_application_tl tl,
1804: fnd_lookup_values v
1805: where s.sel_enum_id = c_rec.SEL_ENUM_ID
1806: and tl.application_id = s.APPLICATION_ID
1807: and v.lookup_type = s.WORK_Q_LABEL_LU_TYPE
1808: and v.lookup_code = s.WORK_Q_LABEL_LU_CODE

Line 2055: fnd_lookup_values_vl

2051: meaning
2052: into
2053: l_node_label
2054: from
2055: fnd_lookup_values_vl
2056: where
2057: (lookup_type = 'IEU_NODE_LABELS') and
2058: (view_application_id = 696) and
2059: (lookup_code = 'IEU_MEDIA_LBL');

Line 2576: fnd_lookup_values v

2572: cursor c_dproc (enum_id NUMBER, app_id NUMBER, l_type VARCHAR2, l_code VARCHAR2)is
2573: select distinct v.meaning, s.sel_enum_id, s.refresh_proc, tl.application_name
2574: from ieu_uwq_sel_enumerators s,
2575: fnd_application_tl tl,
2576: fnd_lookup_values v
2577: where s.sel_enum_id = enum_id
2578: and tl.application_id = app_id
2579: and v.lookup_type = l_type
2580: and v.lookup_code = l_code