DBA Data[Home] [Help]

APPS.EAM_TEXT_UTIL dependencies on WIP_DISCRETE_JOBS

Line 420: FROM WIP_ENTITIES we,WIP_DISCRETE_JOBS wdj,CSI_ITEM_INSTANCES cii,

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
424: WHERE we.wip_entity_id = p_wip_entity_id

Line 467: eam_work_order_text ewot,wip_discrete_jobs wdj

463: wdj.activity_type,wdj.activity_cause,wdj.activity_source
464: INTO
465: l_wip_entity_id,l_org_id,l_priority,l_work_order_type,l_activity_type,l_activity_cause,l_activity_source
466: FROM
467: eam_work_order_text ewot,wip_discrete_jobs wdj
468: WHERE
469: ewot.rowid = p_rowid
470: AND ewot.wip_entity_id = wdj.wip_entity_id;
471: