DBA Data[Home] [Help]

APPS.EAM_TEXT_UTIL dependencies on FND_LOOKUP_VALUES

Line 174: FROM fnd_lookup_values

170: WHERE meaav.maintenance_object_id = p_instance_id;
171:
172: CURSOR lookup_meaning(p_lookup_type VARCHAR2, p_lookup_code NUMBER) IS
173: SELECT meaning
174: FROM fnd_lookup_values
175: WHERE lookup_type = p_lookup_type
176: AND lookup_code = p_lookup_code;
177:
178: /* Search based on Activity and meter will be enabled in future

Line 437: FROM fnd_lookup_values

433: AND mp.maint_organization_id = p_org_id;
434:
435: CURSOR lookup_meaning(p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS
436: SELECT meaning
437: FROM fnd_lookup_values
438: WHERE lookup_type = p_lookup_type
439: AND lookup_code = p_lookup_code;
440:
441: CURSOR status(p_wip_entity_id NUMBER) IS

Line 444: EAM_WO_STATUSES_TL ewst,FND_LOOKUP_VALUES flv

440:
441: CURSOR status(p_wip_entity_id NUMBER) IS
442: SELECT NVL(ewst.user_defined_status,flv.meaning) as value
443: FROM EAM_WORK_ORDER_DETAILS ewod, EAM_WO_STATUSES_B ewsb,
444: EAM_WO_STATUSES_TL ewst,FND_LOOKUP_VALUES flv
445: WHERE ewod.wip_entity_id = p_wip_entity_id
446: AND ewod.user_defined_status_id = ewsb.status_id
447: AND ewsb.status_id = ewst.status_id(+)
448: AND flv.lookup_type(+) = 'WIP_JOB_STATUS'