DBA Data[Home] [Help]

APPS.EAM_TEXT_UTIL dependencies on CSI_ITEM_INSTANCES

Line 238: , csi_item_instances cii

234: INTO
235: l_instance_id, l_org_id, l_eam_item_type, l_criticality_code, l_buffer
236: FROM
237: eam_asset_text eat
238: , csi_item_instances cii
239: , mtl_system_items_b_kfv msi
240: , mtl_categories_kfv mck
241: WHERE
242: eat.rowid = p_rowid

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