DBA Data[Home] [Help]

APPS.EAM_SETNAME_PUB dependencies on MTL_PARAMETERS

Line 506: from eam_pm_schedulings eps, csi_item_instances cii, mtl_parameters mp

502: select 'Y' into l_exists from dual
503: where exists
504: (
505: select eps.*
506: from eam_pm_schedulings eps, csi_item_instances cii, mtl_parameters mp
507: where eps.set_name_id = l_set_name_id
508: and eps.maintenance_object_id = cii.instance_id
509: and cii.last_vld_organization_id = mp.organization_id
510: and mp.maint_organization_id <> p_organization_id