eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_WO_VALIDATE_PVT dependencies on MTL_PARAMETERS

Line 183: from mtl_parameters mp

179: l_disable_date date;
180: begin
181: select 1
182: into g_dummy
183: from mtl_parameters mp
184: where mp.organization_id = p_eam_wo_rec.organization_id;
185:
186: select nvl(hou.date_to,sysdate+1)
187: into l_disable_date

Line 229: from mtl_parameters mp

225: begin
226:
227: select 1
228: into g_dummy
229: from mtl_parameters mp
230: where mp.eam_enabled_flag = 'Y'
231: and mp.organization_id = p_eam_wo_rec.organization_id;
232:
233: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 259: from wip_eam_parameters wep, mtl_parameters mp

255: ELSE -- For EAM work orders, if mtl org is EAM enabled, then it must be the same as the maintenance org
256: begin
257: select 1
258: into g_dummy
259: from wip_eam_parameters wep, mtl_parameters mp
260: where wep.organization_id = mp.organization_id
261: and mp.eam_enabled_flag = 'Y'
262: and wep.organization_id = p_eam_wo_rec.organization_id;
263:

Line 433: from csi_item_instances cii, mtl_parameters mp

429: OR (p_eam_wo_rec.transaction_type <> EAM_PROCESS_WO_PVT.G_OPR_CREATE
430: AND l_old_eam_wo_moid <> p_eam_wo_rec.maintenance_object_id) THEN
431: -- Code for create validation
432: select 1 into g_dummy
433: from csi_item_instances cii, mtl_parameters mp
434: where cii.last_vld_organization_id = mp.organization_id
435: and mp.maint_organization_id = p_eam_wo_rec.organization_id
436: and cii.instance_id = p_eam_wo_rec.maintenance_object_id
437: and cii.inventory_item_id = nvl(p_eam_wo_rec.asset_group_id, p_eam_wo_rec.rebuild_item_id)

Line 444: select 1 into g_dummy from mtl_system_items msi, mtl_parameters mp where

440: END IF;
441:
442: ELSIF p_eam_wo_rec.maintenance_object_type = 2 then
443: if (p_eam_wo_rec.maintenance_object_source = 1) then
444: select 1 into g_dummy from mtl_system_items msi, mtl_parameters mp where
445: msi.organization_id = mp.organization_id
446: and mp.maint_organization_id = p_eam_wo_rec.organization_id
447: and msi.inventory_item_id = p_eam_wo_rec.maintenance_object_id
448: and rownum = 1;

Line 676: from mtl_parameters mp

672: l_disable_date date;
673: begin
674: select 1
675: into g_dummy
676: from mtl_parameters mp
677: where mp.organization_id = p_eam_wo_rec.organization_id;
678:
679: select nvl(hou.date_to,sysdate+1)
680: into l_disable_date

Line 745: from mtl_parameters mp

741:
742: begin
743: select 1
744: into g_dummy
745: from mtl_parameters mp
746: where mp.eam_enabled_flag = 'Y'
747: and mp.organization_id = p_eam_wo_rec.organization_id;
748:
749: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 776: from wip_eam_parameters wep, mtl_parameters mp

772: ELSE -- For EAM work orders, if mtl org is EAM enabled, then it must be the same as the maintenance org
773: begin
774: select 1
775: into g_dummy
776: from wip_eam_parameters wep, mtl_parameters mp
777: where wep.organization_id = mp.organization_id
778: and mp.eam_enabled_flag = 'Y'
779: and wep.organization_id = p_eam_wo_rec.organization_id;
780:

Line 859: from csi_item_instances cii, mtl_parameters mp

855: OR (p_eam_wo_rec.transaction_type <> EAM_PROCESS_WO_PVT.G_OPR_CREATE
856: AND p_eam_wo_rec.maintenance_object_id <> p_old_eam_wo_rec.maintenance_object_id) THEN
857: -- Code for creation
858: select 1 into g_dummy
859: from csi_item_instances cii, mtl_parameters mp
860: where cii.last_vld_organization_id = mp.organization_id
861: and mp.maint_organization_id = p_eam_wo_rec.organization_id
862: and cii.instance_id = p_eam_wo_rec.maintenance_object_id;
863: END IF;

Line 871: from mtl_system_items msi, mtl_parameters mp

867: elsif (p_eam_wo_rec.maintenance_object_type = 2) then
868: if (p_eam_wo_rec.maintenance_object_source = 1) then
869: select 1
870: into g_dummy
871: from mtl_system_items msi, mtl_parameters mp
872: where msi.organization_id = mp.organization_id
873: and mp.maint_organization_id = p_eam_wo_rec.organization_id
874: and inventory_item_id = p_eam_wo_rec.maintenance_object_id
875: and rownum = 1;

Line 960: from mtl_system_items msi, csi_item_instances cii, mtl_parameters mp

956: end if;
957:
958: select 1
959: into g_dummy
960: from mtl_system_items msi, csi_item_instances cii, mtl_parameters mp
961: where cii.inventory_item_id = p_eam_wo_rec.asset_group_id
962: and cii.inventory_item_id = msi.inventory_item_id
963: and cii.last_vld_organization_id = mp.organization_id
964: and msi.organization_id = mp.organization_id

Line 1089: from mtl_system_items msi, mtl_parameters mp

1085: IF p_eam_wo_rec.maintenance_object_source = 2 then -- for fix 9313320 do not check maint org for CMRO
1086:
1087: select 1
1088: into g_dummy
1089: from mtl_system_items msi, mtl_parameters mp
1090: where msi.inventory_item_id = p_eam_wo_rec.rebuild_item_id
1091: and msi.organization_id = mp.organization_id
1092: -- and mp.maint_organization_id = p_eam_wo_rec.organization_id
1093: and msi.eam_item_type = 3

Line 1099: from mtl_system_items msi, mtl_parameters mp

1095:
1096: else
1097: select 1
1098: into g_dummy
1099: from mtl_system_items msi, mtl_parameters mp
1100: where msi.inventory_item_id = p_eam_wo_rec.rebuild_item_id
1101: and msi.organization_id = mp.organization_id
1102: and mp.maint_organization_id = p_eam_wo_rec.organization_id
1103: and msi.eam_item_type = 3

Line 1147: from csi_item_instances cii, mtl_parameters mp

1143: p_eam_wo_rec.rebuild_serial_number is not null) then
1144:
1145: select 1
1146: into g_dummy
1147: from csi_item_instances cii, mtl_parameters mp
1148: where cii.inventory_item_id = p_eam_wo_rec.rebuild_item_id
1149: and cii.last_vld_organization_id = mp.organization_id
1150: and mp.maint_organization_id = p_eam_wo_rec.organization_id
1151: and cii.serial_number = p_eam_wo_rec.rebuild_serial_number

Line 1233: from mtl_system_items msi, mtl_parameters mp

1229: and p_eam_wo_rec.maintenance_object_source = 1 THEN -- SKIP FOR CMRO
1230:
1231: select serial_number_control_code
1232: into g_dummy
1233: from mtl_system_items msi, mtl_parameters mp
1234: where msi.inventory_item_id = p_eam_wo_rec.rebuild_item_id
1235: and msi.organization_id = mp.organization_id
1236: and mp.maint_organization_id = p_eam_wo_rec.organization_id and rownum = 1;
1237:

Line 1288: mtl_serial_numbers msn1, csi_item_instances cii, mtl_parameters mp, csi_item_instances cii1

1284:
1285: SELECT 1
1286: INTO g_dummy
1287: FROM mtl_object_genealogy mog, mtl_serial_numbers msn, wip_discrete_jobs wdj,
1288: mtl_serial_numbers msn1, csi_item_instances cii, mtl_parameters mp, csi_item_instances cii1
1289: WHERE p_eam_wo_rec.rebuild_item_id is not null
1290: and cii.instance_id = p_eam_wo_rec.maintenance_object_id
1291: and cii.last_vld_organization_id = mp.organization_id
1292: and mp.maint_organization_id = p_eam_wo_rec.organization_id

Line 2124: FROM mtl_project_v mpv, pjm_project_parameters_v ppp, mtl_parameters mp

2120: ))
2121: THEN
2122: SELECT distinct mpv.project_id --this query will return multiple rows if the project has tasks
2123: INTO g_dummy
2124: FROM mtl_project_v mpv, pjm_project_parameters_v ppp, mtl_parameters mp
2125: WHERE mpv.project_id = ppp.project_id
2126: AND mpv.project_id = p_eam_wo_rec.project_id
2127: AND ppp.organization_id = p_eam_wo_rec.organization_id
2128: AND ppp.organization_id = mp.organization_id

Line 2361: from bom_calendar_dates bcd, mtl_parameters mp

2357: if p_eam_wo_rec.requested_start_date is not null then
2358:
2359: select 1
2360: into g_dummy
2361: from bom_calendar_dates bcd, mtl_parameters mp
2362: where mp.organization_id = p_eam_wo_rec.organization_id
2363: and mp.calendar_code = bcd.calendar_code
2364: and mp.calendar_exception_set_id = bcd.exception_set_id
2365: and bcd.calendar_date = trunc(p_eam_wo_rec.requested_start_date);

Line 2371: from bom_calendar_dates bcd, mtl_parameters mp

2367:
2368: if p_eam_wo_rec.due_date is not null then
2369: select 1
2370: into g_dummy
2371: from bom_calendar_dates bcd, mtl_parameters mp
2372: where mp.organization_id = p_eam_wo_rec.organization_id
2373: and mp.calendar_code = bcd.calendar_code
2374: and mp.calendar_exception_set_id = bcd.exception_set_id
2375: and bcd.calendar_date = trunc(p_eam_wo_rec.due_date);

Line 2450: mtl_parameters mp

2446: if(is_unit_effective_item and p_eam_wo_rec.end_item_unit_number is not null) then
2447: select 1
2448: into g_dummy
2449: from pjm_unit_numbers_lov_v pun,
2450: mtl_parameters mp
2451: where pun.unit_number = p_eam_wo_rec.end_item_unit_number
2452: and mp.organization_id = p_eam_wo_rec.organization_id
2453: and mp.master_organization_id = pun.master_organization_id;
2454: end if;