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 184: from mtl_parameters mp

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

Line 228: from wip_eam_parameters wep, mtl_parameters mp

224: begin
225:
226: select 1
227: into g_dummy
228: from wip_eam_parameters wep, mtl_parameters mp
229: where wep.organization_id = mp.organization_id
230: and mp.eam_enabled_flag = 'Y'
231: and wep.organization_id = p_eam_wo_rec.organization_id;
232:

Line 399: from csi_item_instances cii, mtl_parameters mp

395: OR (p_eam_wo_rec.transaction_type <> EAM_PROCESS_WO_PVT.G_OPR_CREATE
396: AND l_old_eam_wo_moid <> p_eam_wo_rec.maintenance_object_id) THEN
397: -- Code for create validation
398: select 1 into g_dummy
399: from csi_item_instances cii, mtl_parameters mp
400: where cii.last_vld_organization_id = mp.organization_id
401: and mp.maint_organization_id = p_eam_wo_rec.organization_id
402: and cii.instance_id = p_eam_wo_rec.maintenance_object_id
403: and cii.inventory_item_id = nvl(p_eam_wo_rec.asset_group_id, p_eam_wo_rec.rebuild_item_id)

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

406: END IF;
407:
408: ELSIF p_eam_wo_rec.maintenance_object_type = 2 then
409: if (p_eam_wo_rec.maintenance_object_source = 1) then
410: select 1 into g_dummy from mtl_system_items msi, mtl_parameters mp where
411: msi.organization_id = mp.organization_id
412: and mp.maint_organization_id = p_eam_wo_rec.organization_id
413: and msi.inventory_item_id = p_eam_wo_rec.maintenance_object_id
414: and rownum = 1;

Line 643: from mtl_parameters mp

639: begin
640:
641: select 1
642: into g_dummy
643: from mtl_parameters mp
644: where mp.organization_id = p_eam_wo_rec.organization_id;
645:
646: select nvl(hou.date_to,sysdate+1)
647: into l_disable_date

Line 710: from wip_eam_parameters wep, mtl_parameters mp

706: begin
707:
708: select 1
709: into g_dummy
710: from wip_eam_parameters wep, mtl_parameters mp
711: where wep.organization_id = mp.organization_id
712: and mp.eam_enabled_flag = 'Y'
713: and wep.organization_id = p_eam_wo_rec.organization_id;
714:

Line 793: from csi_item_instances cii, mtl_parameters mp

789: OR (p_eam_wo_rec.transaction_type <> EAM_PROCESS_WO_PVT.G_OPR_CREATE
790: AND p_eam_wo_rec.maintenance_object_id <> p_old_eam_wo_rec.maintenance_object_id) THEN
791: -- Code for creation
792: select 1 into g_dummy
793: from csi_item_instances cii, mtl_parameters mp
794: where cii.last_vld_organization_id = mp.organization_id
795: and mp.maint_organization_id = p_eam_wo_rec.organization_id
796: and cii.instance_id = p_eam_wo_rec.maintenance_object_id;
797: END IF;

Line 805: from mtl_system_items msi, mtl_parameters mp

801: elsif (p_eam_wo_rec.maintenance_object_type = 2) then
802: if (p_eam_wo_rec.maintenance_object_source = 1) then
803: select 1
804: into g_dummy
805: from mtl_system_items msi, mtl_parameters mp
806: where msi.organization_id = mp.organization_id
807: and mp.maint_organization_id = p_eam_wo_rec.organization_id
808: and inventory_item_id = p_eam_wo_rec.maintenance_object_id
809: and rownum = 1;

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

890: end if;
891:
892: select 1
893: into g_dummy
894: from mtl_system_items msi, csi_item_instances cii, mtl_parameters mp
895: where cii.inventory_item_id = p_eam_wo_rec.asset_group_id
896: and cii.inventory_item_id = msi.inventory_item_id
897: and cii.last_vld_organization_id = mp.organization_id
898: and msi.organization_id = mp.organization_id

Line 1020: from mtl_system_items msi, mtl_parameters mp

1016:
1017: if (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE and p_eam_wo_rec.rebuild_item_id is not null) then
1018: select 1
1019: into g_dummy
1020: from mtl_system_items msi, mtl_parameters mp
1021: where msi.inventory_item_id = p_eam_wo_rec.rebuild_item_id
1022: and msi.organization_id = mp.organization_id
1023: and mp.maint_organization_id = p_eam_wo_rec.organization_id
1024: and msi.eam_item_type = 3

Line 1067: from csi_item_instances cii, mtl_parameters mp

1063: p_eam_wo_rec.rebuild_serial_number is not null) then
1064:
1065: select 1
1066: into g_dummy
1067: from csi_item_instances cii, mtl_parameters mp
1068: where cii.inventory_item_id = p_eam_wo_rec.rebuild_item_id
1069: and cii.last_vld_organization_id = mp.organization_id
1070: and mp.maint_organization_id = p_eam_wo_rec.organization_id
1071: and cii.serial_number = p_eam_wo_rec.rebuild_serial_number

Line 1153: from mtl_system_items msi, mtl_parameters mp

1149: and p_eam_wo_rec.maintenance_object_source = 1 THEN -- SKIP FOR CMRO
1150:
1151: select serial_number_control_code
1152: into g_dummy
1153: from mtl_system_items msi, mtl_parameters mp
1154: where msi.inventory_item_id = p_eam_wo_rec.rebuild_item_id
1155: and msi.organization_id = mp.organization_id
1156: and mp.maint_organization_id = p_eam_wo_rec.organization_id and rownum = 1;
1157:

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

1204:
1205: SELECT 1
1206: INTO g_dummy
1207: FROM mtl_object_genealogy mog, mtl_serial_numbers msn, wip_discrete_jobs wdj,
1208: mtl_serial_numbers msn1, csi_item_instances cii, mtl_parameters mp, csi_item_instances cii1
1209: WHERE p_eam_wo_rec.rebuild_item_id is not null
1210: and cii.instance_id = p_eam_wo_rec.maintenance_object_id
1211: and cii.last_vld_organization_id = mp.organization_id
1212: and mp.maint_organization_id = p_eam_wo_rec.organization_id

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

2040: ))
2041: THEN
2042: SELECT distinct mpv.project_id --this query will return multiple rows if the project has tasks
2043: INTO g_dummy
2044: FROM mtl_project_v mpv, pjm_project_parameters_v ppp, mtl_parameters mp
2045: WHERE mpv.project_id = ppp.project_id
2046: AND mpv.project_id = p_eam_wo_rec.project_id
2047: AND ppp.organization_id = p_eam_wo_rec.organization_id
2048: AND ppp.organization_id = mp.organization_id

Line 2281: from bom_calendar_dates bcd, mtl_parameters mp

2277: if p_eam_wo_rec.requested_start_date is not null then
2278:
2279: select 1
2280: into g_dummy
2281: from bom_calendar_dates bcd, mtl_parameters mp
2282: where mp.organization_id = p_eam_wo_rec.organization_id
2283: and mp.calendar_code = bcd.calendar_code
2284: and mp.calendar_exception_set_id = bcd.exception_set_id
2285: and bcd.calendar_date = trunc(p_eam_wo_rec.requested_start_date);

Line 2291: from bom_calendar_dates bcd, mtl_parameters mp

2287:
2288: if p_eam_wo_rec.due_date is not null then
2289: select 1
2290: into g_dummy
2291: from bom_calendar_dates bcd, mtl_parameters mp
2292: where mp.organization_id = p_eam_wo_rec.organization_id
2293: and mp.calendar_code = bcd.calendar_code
2294: and mp.calendar_exception_set_id = bcd.exception_set_id
2295: and bcd.calendar_date = trunc(p_eam_wo_rec.due_date);

Line 2370: mtl_parameters mp

2366: if(is_unit_effective_item and p_eam_wo_rec.end_item_unit_number is not null) then
2367: select 1
2368: into g_dummy
2369: from pjm_unit_numbers_lov_v pun,
2370: mtl_parameters mp
2371: where pun.unit_number = p_eam_wo_rec.end_item_unit_number
2372: and mp.organization_id = p_eam_wo_rec.organization_id
2373: and mp.master_organization_id = pun.master_organization_id;
2374: end if;