DBA Data[Home] [Help]

APPS.EAM_TEXT_UTIL dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 184: mtl_system_items_b_kfv msi

180: CURSOR Activity(p_instance_id NUMBER) IS
181: SELECT
182: msi.concatenated_segments as value
183: FROM
184: mtl_system_items_b_kfv msi
185: , mtl_eam_asset_activities meaa
186: WHERE
187: meaa.maintenance_object_id = p_instance_id
188: AND meaa.maintenance_object_type = 3

Line 239: , mtl_system_items_b_kfv msi

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
243: AND eat.instance_id = cii.instance_id

Line 422: BOM_DEPARTMENTS bd, MTL_SYSTEM_ITEMS_B_KFV msik, MTL_SYSTEM_ITEMS_B_KFV msik1,

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
426: AND wdj.wip_entity_id = ewod.wip_entity_id