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_SYSTEM_ITEMS

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 416: select 1 into g_dummy from mtl_system_items where

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;
415: elsif (p_eam_wo_rec.maintenance_object_source = 2) then
416: select 1 into g_dummy from mtl_system_items where
417: organization_id = p_eam_wo_rec.organization_id
418: and inventory_item_id = p_eam_wo_rec.maintenance_object_id;
419: end if;
420: 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 813: from mtl_system_items

809: and rownum = 1;
810: elsif (p_eam_wo_rec.maintenance_object_source = 2) then
811: select 1
812: into g_dummy
813: from mtl_system_items
814: where organization_id = p_eam_wo_rec.organization_id
815: and inventory_item_id = p_eam_wo_rec.maintenance_object_id;
816: end if;
817:

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 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 1735: from mtl_system_items

1731: if p_eam_wo_rec.asset_activity_id is not null and p_eam_wo_rec.asset_activity_id <> FND_API.G_MISS_NUM then
1732:
1733: select 1
1734: into g_dummy
1735: from mtl_system_items
1736: where organization_id = p_eam_wo_rec.organization_id
1737: and inventory_item_id = p_eam_wo_rec.asset_activity_id
1738: and eam_item_type = 2;
1739:

Line 1829: from mtl_eam_asset_activities meaa, mtl_system_items msi

1825: if (p_eam_wo_rec.maintenance_object_type = 3) then
1826:
1827: select meaa.start_date_active, meaa.end_date_active
1828: into l_start_date, l_end_date
1829: from mtl_eam_asset_activities meaa, mtl_system_items msi
1830: where meaa.asset_activity_id = p_eam_wo_rec.asset_activity_id
1831: and meaa.maintenance_object_type = 3
1832: and nvl(meaa.tmpl_flag, 'N') = 'N'
1833: and meaa.maintenance_object_id = p_eam_wo_rec.maintenance_object_id

Line 1843: from mtl_eam_asset_activities meaa,mtl_system_items msi

1839: if (p_eam_wo_rec.maintenance_object_type = 2) then
1840:
1841: select min(meaa.start_date_active), min(meaa.end_date_active)
1842: into l_start_date, l_end_date
1843: from mtl_eam_asset_activities meaa,mtl_system_items msi
1844: where meaa.asset_activity_id = p_eam_wo_rec.asset_activity_id
1845: and meaa.maintenance_object_type = 2
1846: and meaa.maintenance_object_id = p_eam_wo_rec.maintenance_object_id
1847: and msi.organization_id = p_eam_wo_rec.organization_id