DBA Data[Home] [Help]

APPS.EAM_TEXT_UTIL dependencies on MTL_PARAMETERS

Line 272: mtl_parameters mp

268: BEGIN
269: SELECT bd.department_code ||' '|| mel.location_codes ||' '|| eomd.accounting_class_code
270: INTO l_buffer
271: FROM eam_org_maint_defaults eomd, bom_departments bd, mtl_eam_locations mel,
272: mtl_parameters mp
273: WHERE mp.organization_id = l_org_id AND mp.maint_organization_id = eomd.organization_id
274: AND eomd.object_id = l_instance_id AND eomd.object_type = 50
275: AND eomd.owning_department_id = bd.department_id (+) AND eomd.area_id = mel.location_id(+);
276:

Line 423: MTL_PARAMETERS mp

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
427: AND wdj.owning_department = bd.department_id(+)