DBA Data[Home] [Help]

APPS.EAM_TEXT_UTIL dependencies on EAM_WO_STATUSES_TL

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'