DBA Data[Home] [Help]

APPS.EAM_TEXT_UTIL dependencies on PJM_PROJECT

Line 418: ' '||bd.department_code||' '||PJM_PROJECT.ALL_PROJ_IDTONUM(wdj.project_id)||' '||

414: CURSOR Work_Order(p_wip_entity_id NUMBER,p_maint_obj_type NUMBER,p_org_id NUMBER) IS
415: SELECT (Tag_begin_work_order ||' '||we.wip_entity_name||
416: ' '||wdj.description||' '||cii.instance_number||' '||msik.concatenated_segments||' '||
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,

Line 419: PJM_PROJECT.ALL_TASK_IDTONUM(wdj.task_id)) as value

415: SELECT (Tag_begin_work_order ||' '||we.wip_entity_name||
416: ' '||wdj.description||' '||cii.instance_number||' '||msik.concatenated_segments||' '||
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