APPS.EAM_WO_VALIDATE_PVT dependencies on MTL_SYSTEM_ITEMS

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

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;
449: elsif (p_eam_wo_rec.maintenance_object_source = 2) then
450: select 1 into g_dummy from mtl_system_items where
451: organization_id = p_eam_wo_rec.organization_id
452: and inventory_item_id = p_eam_wo_rec.maintenance_object_id;
453: end if;
454: 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 879: from mtl_system_items

875: and rownum = 1;
876: elsif (p_eam_wo_rec.maintenance_object_source = 2) then
877: select 1
878: into g_dummy
879: from mtl_system_items
880: where organization_id = p_eam_wo_rec.organization_id
881: and inventory_item_id = p_eam_wo_rec.maintenance_object_id;
882: end if;
883:

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

1811: 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
1812:
1813: select 1
1814: into g_dummy
1815: from mtl_system_items
1816: where organization_id = p_eam_wo_rec.organization_id
1817: and inventory_item_id = p_eam_wo_rec.asset_activity_id
1818: and eam_item_type = 2;
1819:

Line 1909: from mtl_eam_asset_activities meaa, mtl_system_items msi

1905: if (p_eam_wo_rec.maintenance_object_type = 3) then
1906:
1907: select meaa.start_date_active, meaa.end_date_active
1908: into l_start_date, l_end_date
1909: from mtl_eam_asset_activities meaa, mtl_system_items msi
1910: where meaa.asset_activity_id = p_eam_wo_rec.asset_activity_id
1911: and meaa.maintenance_object_type = 3
1912: and nvl(meaa.tmpl_flag, 'N') = 'N'
1913: and meaa.maintenance_object_id = p_eam_wo_rec.maintenance_object_id

Line 1923: from mtl_eam_asset_activities meaa,mtl_system_items msi

1919: if (p_eam_wo_rec.maintenance_object_type = 2) then
1920:
1921: select min(meaa.start_date_active), min(meaa.end_date_active)
1922: into l_start_date, l_end_date
1923: from mtl_eam_asset_activities meaa,mtl_system_items msi
1924: where meaa.asset_activity_id = p_eam_wo_rec.asset_activity_id
1925: and meaa.maintenance_object_type = 2
1926: and meaa.maintenance_object_id = p_eam_wo_rec.maintenance_object_id
1927: and msi.organization_id = p_eam_wo_rec.organization_id