APPS.EAM_TEXT_UTIL dependencies on EAM_WORK_ORDER_DETAILS

Line 421: EAM_WORK_ORDER_DETAILS ewod,

417: cii.serial_number||' '||msik1.concatenated_segments||' '||Tag_end_work_order||
418: ' '||bd.department_code||' '||PJM_PROJECT.ALL_PROJ_IDTONUM(wdj.project_id)||' '||
419: PJM_PROJECT.ALL_TASK_IDTONUM(wdj.task_id)) as value
420: FROM WIP_ENTITIES we,WIP_DISCRETE_JOBS wdj,CSI_ITEM_INSTANCES cii,
421: EAM_WORK_ORDER_DETAILS ewod,
422: BOM_DEPARTMENTS bd, MTL_SYSTEM_ITEMS_B_KFV msik, MTL_SYSTEM_ITEMS_B_KFV msik1,
423: MTL_PARAMETERS mp
424: WHERE we.wip_entity_id = p_wip_entity_id
425: AND we.wip_entity_id = wdj.wip_entity_id

Line 443: FROM EAM_WORK_ORDER_DETAILS ewod, EAM_WO_STATUSES_B ewsb,

439: AND lookup_code = p_lookup_code;
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(+)

Line 889: FROM EAM_WORK_ORDER_DETAILS ewod

885: l_count NUMBER;
886:
887: CURSOR workorders(l_status_id NUMBER) IS
888: SELECT ewod.wip_entity_id,ewod.organization_id
889: FROM EAM_WORK_ORDER_DETAILS ewod
890: WHERE ewod.user_defined_status_id = l_status_id;
891:
892: BEGIN
893: