APPS.EAM_WO_DEFAULT_PVT dependencies on MTL_SYSTEM_ITEMS

Line 346: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_PARAMETERS MP

342: THEN
343: begin
344: SELECT description
345: INTO l_activity_description
346: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_PARAMETERS MP
347: WHERE MSI.inventory_item_id = p_eam_wo_rec.asset_activity_id
348: AND MSI.organization_id = MP.ORGANIZATION_ID
349: AND MP.MAINT_ORGANIZATION_ID = p_eam_wo_rec.organization_id
350: AND rownum = 1;

Line 984: from csi_item_instances cii, mtl_system_items msi

980: , msi.eam_item_type
981: into l_serial_number
982: , l_inventory_item_id
983: , l_eam_item_type
984: from csi_item_instances cii, mtl_system_items msi
985: where cii.last_vld_organization_id = msi.organization_id
986: and cii.inventory_item_id = msi.inventory_item_id
987: and cii.instance_id = p_eam_wo_rec.maintenance_object_id;
988:

Line 999: from mtl_system_items msi, mtl_parameters mp

995: elsif (p_eam_wo_rec.maintenance_object_type = 2) then
996:
997: select inventory_item_id
998: into x_eam_wo_rec.rebuild_item_id
999: from mtl_system_items msi, mtl_parameters mp
1000: where msi.organization_id = mp.organization_id
1001: and mp.maint_organization_id = p_eam_wo_rec.organization_id
1002: and msi.inventory_item_id = p_eam_wo_rec.maintenance_object_id
1003: and rownum = 1;